Techniques for Export Dataset from SAS to Excel (in PC SAS)

[dkanand86]

Hi Everyone,

Please let me know the techniques for this exporting data from PC SAS into Excel. Thanks

Regards

[PGStats]

Click on your dataset in explorer window, select menu File - Export... Follow instructions.

[dkanand86]

I tried this option, but it failed.

[PGStats]

Any error message?

[PGStats]

Fail proof (almost): Export as TAB separated text file and import data in Excel.

[Reeza]

What version of SAS do you have?

libname out xlsx 'C:\test.xlsx';

data out.want;
set sashelp.class;
run;

libname out;

proc export data=sashelp.class outfile='C:\test2.xlsx' dbms=xlsx replace; run;

[dkanand86]

SAS 9.3

[RW9]

As mentioned above there are many ways of getting data to Excel:

-> Export from explorer window in SAS

-> Proc export

-> ods tagsets.excelp

-> libname excel

-> output to CSV

-> DDE

-> Copy and paste

Your question is too vague.  What have you tried, what errors do you get.  Post your code.

[Reeza]

Did any of the options I posted work for you, if not please explain why.

Here's a blog post detailing several methods:

http://blogs.sas.com/content/sasdummy/2012/02/11/export-excel-methods/