topic Re: Techniques for Export Dataset from SAS to Excel (in PC SAS) in SAS Programming

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

dkanand86 — Fri, 04 Dec 2015 03:56:28 GMT

Hi Everyone,

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

Regards

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

PGStats — Fri, 04 Dec 2015 04:10:15 GMT

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

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

dkanand86 — Fri, 04 Dec 2015 04:13:16 GMT

I tried this option, but it failed.

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

PGStats — Fri, 04 Dec 2015 04:22:12 GMT

Any error message?

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

Reeza — Fri, 04 Dec 2015 04:36:52 GMT

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;

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

dkanand86 — Fri, 04 Dec 2015 04:42:56 GMT

SAS 9.3

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

PGStats — Fri, 04 Dec 2015 05:06:35 GMT

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

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

RW9 — Fri, 04 Dec 2015 09:53:51 GMT

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.