Search results for query: *

Hello, I developed a report using Report Studio in Cognos 8.4. Basically, I have one massive master query that generates all the data I need for the report. There are about 30 or so pages, and each page contains about one or two tables or charts based on this master query (enclosed is a...

Hello, I have been using VBA to send Lotus Notes email for a while. The general code is the following: Public Sub SendNotesMail(Subject As String, ByVal Recipient As String, BodyText As String, SaveIt As Boolean) 'Set up the objects required for Automation into lotus notes Dim...

Hi, Is there a VBA code that can tell whether I am opening my Excel spreadsheet in Excel, or in a Web Browser, like IE? I tried Applicaton.name but it always gives me Microsoft Excel as the answer, whether the spreadsheet is opened in Excel or in a web browser. Any help will be...

Hi, Does anyone know the VBA code for the following question: I have four buttons A, B, C, and D on an Excel spreadsheet. Each button is associated with a macro. But instead of four individual macros, I want to associate them with the same macro. When the button is clicked, the macro will...

I came across a program at work that I could not decipher. I googled around and could not find any answers. Can anyone interpret the following code for me (code modified for presentation purposes): data abc; _n_ ++_n_ < n; set xyz point=_n_ ; workstn2 = workstn; set...

Hello, I tried using the following code: Public X(1 to 50) as string But when I compiled it, I got an error message. How can I fix this? Or is it even possible to create an array variable in public? Thanks in advance ~~CW~~

Hi, I have the following question: I have a bunch macro variables defined in a program: %let ADX = 2 %let BDX = 21 %let CDX = 13 %let DDX = 5 %let EDX = 10 later in the program, I have the following macro defined: %macro test(z); data newdates&z; set olddates; if ref in (&&z.dx) and...

I have a large table containing hundreds of data fields. There are two sets of fields I'd like to use in particular: Code1 through Code20, as well as Code1Dt through Code20Dt So in my data step, I have the following: array Code{*} Code1-Code20 which works fine. However, when it comes to...

Hi, I am trying to write a program using VBA in Excel to run a SAS program (a .sas file). Does anyone know how this can be accomplished? Thanks in advance! ~~CW~~

Hi, I have the following problem: in cell A1, I typed "B1+B2". In cell A2, I want to convert the text in A1 into a formula and then calculate that formula. So if B1 = 5 and B2 = 6, A2 should read 11, and if B1 = 3 and B2 = -1, A2 should return 2. Of course, I could have just use the formula...

Hi, I have the following question: I have a form which contains a drop down box and a button. The values of the drop down box are texts of partial VBA code. Underneath the button is a VBA code, which looks roughly like private sub blahblahblah() blah blah blah blah blah blah...

Hi, I have the following code that works on my PC SAS software: filename indat FTP 'data.txt' debug HOST = 'abc.efg.org' USER = 'username' PASS = 'mypassword' RECFM = f LRECL = 9; data...

Hi, I recently installed IIS on my Windows XP Pro. When I tested it using IE (version 6) by using http://localhost, it would open iisstart.asp file without a fuss. However, when I tested it using Mozilla Firefox, it would ask me for a user name and a password. However, I never set any user...

Hi, how do I run a saved sas program from my current sas program? Is there a way to reference a sas program and execute it by somehow calling its name and address? Thanks in advance, Chi ~~CW~~

In SAS Programming, is there such a syntax Do.... Until ? In my example, I want to run a SAS macro repeatedly until the value in a certain table is equal to 0. How would I go about doing that? Thanks in advance, Chi

Hi, Does anyone know anything about how to use PROC SURVEYSELECT? I have a table consisting of a population of households and I want to create a sample from it. The sample will consist of a member selected randomly from within each household. Can anyone give me a hint as to how to go about...