09-19-2014 12:49 PM
I'm trying to export multiple sas datasets to excel where my multiple sas datasets are multiple sheets in 1 excel file. I wrote a macro for this. I'm sure I made some mistakes as I'm new to macro and still in learning phase. I have about 40 sas datasets. I would really appreciate if you could help me with this.
libname a "c:\sasdata";
proc export data=&data.
%imp (file= "c:\sasdata\blood_result.xls",data= a.rbc,sheet= rbc);
%imp (file= "c:\sasdata\blood_result.xls",data= a.wbc,sheet= wbc);
09-19-2014 12:56 PM
When you the libname excel access then the libname is a excel file and sheets are the same as tables in SAS.
This is posted in analytics U. Dou you have a desktop version (using c or the UE running linux in a VM on your desktop?
My human brains as SAS syntax checker does not see any problems with your code.
As it is human it is having a strong error correction mode that code could have still many mistakes.
09-19-2014 01:03 PM
Thank you, Jaap for you reply. I'm new to this forum as well so I'm not sure where I should have posted. Well, I have a desktop and running windows.