I would like to prevent an output file from SAS from being overwritten if that SAS program is run a second time.  To do this I have assigned two filerefs using two FILENAME statements.  Then in the data step that writes the output, I have tried to use the FEXIST function to test if the output file already exists.  If it does, I would like to write the output to a second file.  Here is some pseudo code I have written: filename this "C:\this.dat"; filename that "C:\that.dat"; . . . data here;    set there;    if (fexist("this")) then       file that;    else       file this;    put a b c d; run; When I use this code, the file "this.dat" is always written and the file "that.dat" is always zeroed out.  What am I doing wrong? ... View more

I have some data that I am analyzing using proc summary.  The following example produces output that is really close to what I need: data input;    input source sex $ weight;    datalines; 176 M 2240 176 F 1814 177 M 2380 177 F 1910 178 M 2190 178 F 1790 179 M 2250 179 F 1850 ; run; proc summary data=input;    class source sex;    var weight;    output out=summary mean=weight cv=cv n=no; run; proc print data=summary noobs; run; I would like to group some of the class data together so that the output includes the "176+177" lines shown below: source sex _TYPE_ _FREQ_ weight   cv  no .           0     8   2053 11.4592 8 .  F    1     4   1841  2.8350 4 .  M    1     4   2265  3.5777 4   176           2     2   2027 14.8608 2   177           2     2   2145 15.4937 2   176+177       2     4   2075 15.1234 4   178           2     2   1990 14.2132 2   179           2     2   2050 13.7972 2   176  F    3     1   1814   .     1   176  M    3     1   2240   .     1   177  F    3     1   1910   .     1   177  M    3     1   2380   .     1   176+177  F    3     1   1860   176+177  M    3     1   2310   178  F    3     1   1790   .     1   178  M    3     1   2190   .     1   179  F    3     1   1850   .     1   179  M    3     1   2250   .     1 The only way I can think of doing that is to use several data steps to combine the values for several of my sources and then append the combined data to my original data before running through proc summary.  Is there a more elegant approach? ... View more

I'm trying to read multiple files into a dataset but I'm struggling to find the "best" way to do this.  I know that you can't use macro variables inside a datalines statement but I want to be able to specify the directory from which I am reading at the top.  This example illustrated what I am trying to do.  Can anyone suggest how I might do this? %Let srcdir=c:\foo; %Let basename=bar; Data One;    Infile Datalines;    Length EggFile $152;    Input EggFile $;    Infile dummy FileVar=EggFile end=done;    Do While(not done);       Input this 1-2 that 4;       Output;    End;    Datalines;       "&srcdir\&basename.27.Dat"       "&srcdir\&basename.28.Dat"       "&srcdir\&basename.29.Dat"       "&srcdir\&basename.30.Dat"       "&srcdir\&basename.31.Dat"       "&srcdir\&basename.32.Dat"       "&srcdir\&basename.33.Dat"       "&srcdir\&basename.34.Dat" Run; ... View more

I have a data set that includes severl "defect" columns.  Up to three defects can be recorded in each row.  I'm struggling to write code that will give me a summary of occurrances of all "defects".  For example, take the following data: 0,0,0 1,0,0 1,2,0 5,0,1 0,0,0 0,1,0 0,0,0 5,0,0 0,0,9 0,0,0 There are 10 rows.  Defect number 1 (one) occurs 4 times (40%), defect 2 occurs 1 time (10%), defect 5 occurs 2 times (20%).  I've put together some SAS code that will summarize one column.  I'm having trouble figuring out how to do this for defects in multiple columns.  I also want to add a textual discription of each defect to the output table but I want to get the numbers correct first.  Here is some working sample code.  Can anyone steer me in the right direction? %let nanimals=10; data check3;    infile datalines dlm=',';    input defect1 defect2 defect3;    datalines; 0,0,0 1,0,0 1,2,0 5,0,1 0,0,0 0,1,0 0,0,0 5,0,0 0,0,9 0,0,0 ; proc sort; by defect1; proc summary data=check3; by defect1;  where ((defect1>0 and defect1<20) or (defect2>0 and defect2<20) or (defect3>0 and defect3<20));    var defect2 defect3;    output out=check1 sum=defect2 defect3 n=total; data check2; set check1;    percent=100*total/&nanimals;    format percent 5.1; proc print noobs;    var total percent; title Defect Summary; run; ... View more

I'm trying to write some SAS code that will read in a .xlsx file if it exists, otherwise I would like it to create an empty dataset.  I've written some code but it hangs at the "call execute" line.  Here is what I am trying: data _null_;    if fileexist("c:\test.xlsx") then       call execute('proc import datafile="c:\test.xlsx" out=work.lixi dbms=excelcs replace;');    else       call execute('data lixi;infile datalines;input wingband;datalines;;'); run; What am I doing wrong?  Is there a better way to do this? ... View more