topic Re: SAS to Excel in SAS Procedures

SAS to Excel

deleted_user — Sun, 04 Jul 2010 06:51:13 GMT

Hi All,

I have an output data set 'ext4' in work.I want to export this ODS to excel. I tried google serach on how to do this , but did not get much help.

kindly could anyone please sugeest me on this.

kindest regards,
Mark

Re: SAS to Excel

peatjohnston — Sun, 04 Jul 2010 11:58:50 GMT

Hi Mark,

If you are using pc SAS, you should be able to go to File --> Export Data
and a new window will open up and walk you through the process of creating and naming the Excel file and where to save it.

peat

Re: SAS to Excel

Cynthia_sas — Sun, 04 Jul 2010 17:24:59 GMT

Hi:
For some code examples, see these previous forum postings:
http://support.sas.com/forums/thread.jspa?messageID=7958἖
http://support.sas.com/forums/thread.jspa?messageID=31690篊

For an explanation of all the various ODS techniques, see this previous forum posting:
http://support.sas.com/forums/thread.jspa?messageID=8719∏

And the answer to this question back in March, still applies, as well:
http://support.sas.com/forums/thread.jspa?messageID=33372艜

cynthai

Re: SAS to Excel - Macro for easy reuse

jj030655 — Wed, 14 Jul 2010 21:05:20 GMT

%macro xlsxport(lib,dataset,ssname,sheet);
*XPORT a spreadsheet to c:\xxxx\ssname.xls because everyone will have this folder.;
PROC EXPORT DATA= &lib..&dataset
OUTFILE= "C:\xxxx\yyyy\zzzz\&ssname..xls"
DBMS=EXCEL2000 REPLACE;
sheet=&sheet;
run;
%MEND xlsxport;

to use this...

%xlsxport(work,mydataset,myexcelworkbook,myexcellsheet);

You can adjust the path name to fit your needs.