Desktop productivity for business analysts and programmers

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

Reply
Occasional Contributor
Posts: 15

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

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.

New Contributor
Posts: 3

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

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

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


Contributor
Posts: 73

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

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;

Ask a Question
Discussion stats
  • 2 replies
  • 399 views
  • 0 likes
  • 3 in conversation