I have not tried this but I heard that the libname engine is now part of workstation sas(sometimes called pc sas).   This should copy all data sets in library sashelp to multiple sheets in a workbook   libname xel "d:/xls/sashelp.xlsx"; proc copy in=sashelp out=xel; run;quit;   I nice feature of this is that you get nice sheetnames and a named ranges with the same name as the sheet. ... View more

Survival Probabilities for combinations of risk factors for an R solution based on the SAS Forum IML solution see https://listserv.uga.edu/cgi-bin/wa?A2=SAS-L;f541a941.1610a Slightly reformated HAVE I have a following dataset ID Male Smoker Over60 Survived TED 1 0 0 1 JIM 1 1 0 0 TEX 1 0 1 1 LIZ 0 1 1 0 JOE 1 1 0 1 Out of all Male Smokers only Joe survived 1/8 12.5% survival rate TIM 1 1 0 0 TAD 1 0 1 1 TOM 1 0 1 0 WANT For Male Smokers Jim, Joe and Tim. Only Joe survived 1/8 = .125 For Males over 60 Tex, Tad and Tom, Tex and Tad Survived = 2/8 = .25 For Smokers over 60. NO one survived 0.0 MALE SMOKER OVER60 MALE _ 12.50% 25% (TAD + TOM survived)/8 records SMOKER 12.50% _ 0% OVER60 25% 0% _ SAS SOLUTION ============ * after normalizing you can generalize with many sas procedures beter solution then this one?; data _null_; retain survive1 survive2 survive3 0; format survive: percent7.1; infile datalines eof=dne; input ID $3. Male Smoker Over60 Survived; grp1='Male_Smoker_Survive ';survive1=survive1+male*smoker*survived; grp2='Male_Over60_Survive ';survive2=survive2+male*over60*survived; grp3='Smoker_Over60_Survive ';survive3=survive3+smoker*over60*survived; return; dne: _n_=_n_-1; survive1=survive1/_n_; survive2=survive2/_n_; survive3=survive3/_n_; put @10 "Male " @20 "Smoker" @30 "Over60" ; put @1 "Male" @10 "-" @20 Survive1 @30 Survive2 ; put @1 "Smoker" @10 Survive1 @20 "-" @30 Survive3 ; put @1 "Over60" @10 Survive2 @20 Survive3 @30 "-" ; datalines; TED 1 0 0 1 JIM 1 1 0 0 TEX 1 0 1 1 LIZ 0 1 1 0 JOE 1 1 0 1 TIM 1 1 0 0 TAD 1 0 1 1 TOM 1 0 1 0 ;;;; run;quit; Male Smoker Over60 Male - 12.5% 25.0% Smoker 12.5% - 0.0% Over60 25.0% 0.0% - ... View more

My mistake     I did not understand the questions.     I am very ignorant about EG project files.     It is annoyning that I have to log into SAS forum and cannot reply to SAS forum generated emails to my gmail account.     The return address is 'replies.disabled@sas.com. Also it would be very nice if the latest  postings could be sent to my email or better yet mirroed on SAS-L. There are a lot of skilled programmers on SAS-L who can help. Same goes for Stackoverflow. ... View more

I am a little confused. Why not libname xel "c:/xls/myxls.xlsx"; data arbitrary_name(label="arbitrary_label");; set xel.'sheet1$'n; run;quit; libname xel close; ... View more

If you happen to be using the old text editor you can run these dm commands. Also you can type one on the command line, hit the submit mouse button then '?' to get last submitted command, edit an submit. You can also chain command line statements by separating them with a ';' However as has been stated, your CSVs cannot have issues with headers or data. I like to highlight one at a time and hit RMB. dm "dimport 'c:\temp\tmp0.csv' class0 replace"; dm "dimport 'c:\temp\tmp1.csv' class1 replace"; dm "dimport 'c:\temp\tmp2.csv' class2 replace"; dm "dimport 'c:\temp\tmp3.csv' class3 replace"; dm "dimport 'c:\temp\tmp4.csv' class4 replace"; dm "dimport 'c:\temp\tmp5.csv' class5 replace"; dm "dimport 'c:\temp\tmp6.csv' class6 replace"; dm "dimport 'c:\temp\tmp7.csv' class7 replace"; dm "dimport 'c:\temp\tmp8.csv' class8 replace"; dm "dimport 'c:\temp\tmp9.csv' class9 replace"; ... View more

Good Points Reeza With MS Powershell now available in Unix, I wonder if we will have better connections to Office. Should help with the MS scripting from Unix?. You are right about big companies, however there are many smaller companies and startups without all those products. I wonder if we will be able to mount local drives on unix using powershell 'mount' commands. Mount my C drive? Powershell over PuTTy SSH? Powershell on Unix should really help with SAS admin on hybrid Unix/SAS installations. ... View more

Adobe pro does run on mac osX ... View more

Good points   I don't believe Adobe Pro is open source, runs on OSx and Unix or is a s easy to script.   For non-programmers Adobe Pro is a great product, intuitive with good mouse surfing.   Not sure but MS Word may allow mouse surfing output to PDFs.? ... View more

It might be worth making each child dataset a SAS view. Especially if you plan to doing something immediately with the children. ... View more

This should be faster because it all runs in one address space, but who knows all the details of the dosubl architechure. data have; input id name $ age; cards4; id name age 1 john 25 2 suzy 30 ;;;; run;quit; data _null_; do name='name','age'; call symputx('nam',name); rc=dosubl(resolve(' data &nam; set have(keep=id &nam); run;quit; ')); end; run;quit; ... View more

This should be faster because it all runs in one address space, but who knows all the details og the dosubl architechure. data have; input id name $ age; cards4; id name age 1 john 25 2 suzy 30 ;;;; run;quit; data _null_; do name='name','age'; call symputx('nam',name); rc=dosubl(resolve(' data &nam; set have(keep=id &nam); run;quit; ')); end; run;quit; 146 data _null_; 147 do name='name','age'; 148 call symputx('nam',name); 149 rc=dosubl(resolve(' 150 data &nam; 151 set have(keep=id &nam); 152 run;quit; 153 ')); 154 end; 155 run; SYMBOLGEN: Macro variable NAM resolves to name SYMBOLGEN: Macro variable NAM resolves to name NOTE: There were 3 observations read from the data set WORK.HAVE. NOTE: The data set WORK.NAME has 3 observations and 2 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 1031.71k OS Memory 13792.00k Timestamp 09/13/2016 06:04:42 AM Step Count 31 Switch Count 0 SYMBOLGEN: Macro variable NAM resolves to age SYMBOLGEN: Macro variable NAM resolves to age NOTE: There were 3 observations read from the data set WORK.HAVE. NOTE: The data set WORK.AGE has 3 observations and 2 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds Win 7 32bit SAS 9.3 user cpu time 0.00 seconds system cpu time 0.00 seconds Download and install 9.06 Ghostscipt memory 1031.71k OS Memory 13792.00k Scan the download Timestamp 09/13/2016 06:04:42 AM ... View more