Howard_Schreier's articles:

Items(915) /92 Next >> Last >|

Re: Smallest SAS pgm? #3 0 54 (11/29/2004 3:48:50 AM) comp.soft-sys.sas Sidestepping one debate by looking for the shortest DATA step ... Why the newline? Make it DAT;RU; which is one less keystroke and two fewer stored characters on a WIndows system. On Sun, 28 Nov 2004 23:31:3... Howard_Schreier

Re: SAS to XLS limitation 1 55 (11/28/2004 5:47:57 PM) comp.soft-sys.sas It is certainly possible to segment the data into multiple worksheets. What tool are you using to move data from SAS to Excel? There are many possibilities. However, unless there is some natural grouping whic... Howard_Schreier

Re: Formats and Macros #3 0 36 (11/27/2004 3:16:03 AM) comp.soft-sys.sas SAS uses the BEST12. format to do the implicit numeric-to-character conversion. That does seem kind of dumb; why not use the format declared? The reason I think is at the point where the conversion is needed, S... Howard_Schreier

Re: Programming help: selecting observations #5 0 51 (11/24/2004 9:50:25 PM) comp.soft-sys.sas The double DoW strucure is good for this. In the first loop, determine if there is an error condition and also the relative observation numbers of the start and stop indicators. In the second loop, conditionall... Howard_Schreier

Re: transpose in a non-usual way #3 0 55 (11/24/2004 9:17:07 PM) comp.soft-sys.sas Try data comb; merge input (rename = (var1-var2 = new1-new2) ) input (firstobs=2 keep=var2 rename = (var2=new3) ); if mod (_n_,2)=1; run; That produces the output shown in the example. I'... Howard_Schreier

Re: use LaTeX for your SUGI paper 0 35 (11/24/2004 4:31:07 AM) comp.soft-sys.sas You are right about long lines of small characters. I used larger type and slightly wider margins. See http://www2.sas.com/proceedings/sugi29/247-29.pdf That was done with MS Word; the point holds regardle... Howard_Schreier

Re: TRANSPOSE proc automatically deletes the row/column with missing values? #2 0 44 (11/24/2004 4:23:30 AM) comp.soft-sys.sas The only way I can replicate your results is by making YEAR1 and YEAR2 numeric (using ROMANw. format) while YEAR3 is character. It has nothing to do with missing values or things which look like missing values.... Howard_Schreier

Re: from SAS to MS Access without Proc Export #6 0 33 (11/24/2004 4:14:26 AM) comp.soft-sys.sas To do it with SAS Base software alone, and without an intermediate file, try DDE. On Mon, 22 Nov 2004 15:03:59 -0500, Bill Droogendyk wrote: >Folks: > >I've an application running from my PC via SAS Connect ... Howard_Schreier

Re: Macro to create multiple dates from numeric fields in one dat a set #3 0 40 (11/23/2004 3:45:34 AM) comp.soft-sys.sas I suspect you would be better off with fewer variables. I would probably make treatment type a categorical variable, and get rid of those compound variable names. On Mon, 22 Nov 2004 14:35:55 -0600, Amanda Ren... Howard_Schreier

Re: Executing Excel macros from SAS #2 0 32 (11/23/2004 3:38:22 AM) comp.soft-sys.sas See "Intelligently Launching Microsoft Excel from SAS, Using SCL Functions Ported to Base SAS" by Chris Roper http://www.nesug.org/html/Proceedings/nesug00/cc/cc4015.pdf On Mon, 22 Nov 2004 00:36:09 -0800,... Howard_Schreier

Howard_Schreier's replies:

Items(551) /56 Next >> Last >|

Reading file from Mainframe 1 52 (11/18/2004 5:58:05 PM) comp.soft-sys.sas Dear All, 1- I create a SAS dataset in Mainframe which I need to use in SAS PC, so I use the following code to convert the data set to transport form -----------------------------------------------------------... batawfic (19)

Need Help with Array? 4 41 (11/18/2004 10:54:11 PM) comp.soft-sys.sas Hi, My SAS data set below has been transposed. There are 5 colums: Acct and Cycle1 to Cycle4. I want to add a new field DESIRED_COUNT by counting the number of the cycles of each account has. Please help me... brianvuong (2)

Executing Excel macros from SAS 2 48 (11/22/2004 8:36:09 AM) comp.soft-sys.sas Hello All, I was going through the SUGI 25 paper "Using SAS and DDE to execute VBA macros in Microsoft Excel" that can be found at: www.nesug.org/html/Proceedings/nesug00/cc/cc4016.pdf I need to know if I ca... saurabh.chandra (10)

from SAS to MS Access without Proc Export 7 40 (11/22/2004 8:03:59 PM) comp.soft-sys.sas Folks: I've an application running from my PC via SAS Connect to the Mainframe that harvests some MF data, downloads the data and uses proc export to build an MS Access file. Now and again, the app fails due ... bill_droogendyk (57)

Programming help: selecting observations 5 44 (11/22/2004 8:40:58 PM) comp.soft-sys.sas Hi, I hope that I will get help for programming. My data looks like the following: id event event1 start_date stop_date 1 01/01/96 03/31/96 1 BEG ... dyang (97)

use LaTeX for your SUGI paper 1 49 (11/23/2004 7:56:00 PM) comp.soft-sys.sas ah, yes, it is that time of year again: SUGI acceptances are rolling in and it's time to let people know that if you would like to write a text file of your SUG paper, process it with an application, and get a ... rjf2 (3354)

Formats and Macros 4 43 (11/25/2004 10:04:24 AM) comp.soft-sys.sas Why the following macro does not work as I want? I mean that I'd like in the output the macro variable tday to have a julian format (2004330),while what I get is the variable in sas format (16400)! Does anyone ... menegon.daniele (3)

Smallest SAS pgm? 3 59 (11/28/2004 11:31:36 PM) comp.soft-sys.sas Art: You're right - I'm sitting at home in my 3rd week of convalescence from knee replacment surgery and don't have much else to do. Using SAS V8.2 under WinXP, your SAS program exits to the system an... bruce6525 (10)

Parsing messing name strings - any ideas? 2 44 (11/16/2004 1:31:26 PM) comp.soft-sys.sas I'm working on a data conversion program and need to parse out some messy name strings. There may be one or more alias names in the string and to complicate things some of the names may be maiden names (follow... zqy3 (7)

copy and running files 2 45 (11/17/2004 7:08:08 PM) comp.soft-sys.sas I have a problem thatI hope I can get some help with. I currently have a program that I have to do time consuming steps with that I am trying to streamline. My steps are as follows: 1)Manully copy "Master" f... saultemp (19)