How to export and combine worksheet as an excel file in sas EG

[sugita]

Hi,

I have several process and querries in sas EG that will produce a separate excel file (or csv)

I was wondering if there is a way in sas to combine all of these excel files into one single excel file with multiple worksheet that represent each and every original excel file.

[Mzee]

Read the article, it might help in what you are thinking of doing.

http://support.sas.com/resources/papers/proceedings12/150-2012.pdf

[robby_beum]

I use EG 4.3 and write PROC EXPORT statements pretty much all the time. In the following examples, it writes to the same excel file "Output_Listing.xls" creating multiple worksheets...hope this helps:

code here...

proc export data=P06.what_I_have
   outfile="\\Server01\Reports\directories\output\Output_Listing.xls"
   dbms=excelcs replace;
   sheet="Worksheet 1";
   SERVER='server_name';
   PORT=9621;
run;

more code here or even another program...

proc export data=P06.what_I_have2
   outfile="\\Server01\Reports\directories\output\Output_Listing.xls"
   dbms=excelcs replace;
   sheet="Worksheet  2";
   SERVER='server_name';
   PORT=9621;
run;

more code here or even another program...

proc export data=P06.what_I_have3
   outfile="\\Server01\Reports\directories\output\Output_Listing.xls"
   dbms=excelcs replace;
   sheet="Worksheet  3";
   SERVER='server_name';
   PORT=9621;
run;