07-26-2013 01:08 PM
You may want to try ods tagsets.excelxp instead of proc export.
So, you could do something like this:
ods tagsets.excelxp file = "....\my_file.xls";
proc print data = your_data;run;
ods tagsets.excelxp close;
07-26-2013 01:31 PM
Sorry, I had to figure out how to use the options(sheet_label...);
So here is something that could work:
ods tagsets.excelxp file = "&file_path.\my_file.xls" ;
%do i = 1 %to 4;
ods tagsets.excelxp options(sheet_label = "sheet_Name_&i" ); ;
proc print data = &dsname.;run;
ods _all_ close;
So, you first initialize (or whatever the word is) the ODS TAGSETS.EXCELXP file=....
Then you use another ODS TAGSETS.EXCELXP OPTIONS(sheet_label...) for each of your export...
I hope this helps.
Need further help from the community? Please ask a new question.