Proc Export

[sravanpathu]

Hi All,

How to export multiple datasets to a single Excel file and arranging them as Work sheets using proc export.

Regards,

Sravan

[art297]

Do you license SAS/Access for pcfile formats, what version of SAS are you using, what kind of computer are you using, and is it 32 or 64 bit?

[sravanpathu]

SAS EG 4.3

We had access for PC Files.

32bit

[Ksharp]

Easy.

proc export data=sashelp.class outfile='c:\temp\x.xls' dbms=excel replace;sheet='class';run;

proc export data=sashelp.air outfile='c:\temp\x.xls' dbms=excel replace;sheet='air';run;

Ksharp

[sravanpathu]

Thank you

If i want to replace only Air Sheet  then what i have to do

[Ksharp]

Just run the code again, air sheet will be updated .