Help using Base SAS procedures

Proc Export

Reply
Contributor
Posts: 26

Proc Export

Hi All,

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

Regards,

Sravan

PROC Star
Posts: 7,356

Re: Proc Export

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?

Contributor
Posts: 26

Re: Proc Export

SAS EG 4.3

We had access for PC Files.

32bit

Super User
Posts: 9,657

Re: Proc Export

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

Contributor
Posts: 26

Re: Proc Export

Thank you

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

Super User
Posts: 9,657

Re: Proc Export

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

Ask a Question
Discussion stats
  • 5 replies
  • 260 views
  • 0 likes
  • 3 in conversation