topic Re: Exporting to Excel Spreadsheet in SAS Programming

Exporting to Excel Spreadsheet

cneed — Fri, 24 Jan 2020 00:02:39 GMT

How can I export a sas table to an excel spreadsheet?

Thanks!

Re: Exporting to Excel Spreadsheet

sustagens — Fri, 24 Jan 2020 01:34:43 GMT

proc export data = sashelp.baseball (where=(Team="Atlanta")) 
outfile = "G:\SAS Downloads\Baseball_Teams.xls" 
dbms = xls replace;
sheet = "Atlanta";
run;

Re: Exporting to Excel Spreadsheet

unison — Fri, 24 Jan 2020 03:32:45 GMT

If you can utilize the xlsx engine, I think this is the cleanest way to do it:

libname xlout xlsx '/folders/myfolders/SASHelp.xlsx';
proc datasets nolist;
 copy in=sashelp out=xlout;
 select shoes class retail / memtype=data;
run; quit;
libname xlout clear;

Re: Exporting to Excel Spreadsheet

cneed — Fri, 24 Jan 2020 03:56:38 GMT

@sustagens Is it possible to just select certain columns of the dataset to export? This is the code I have tried and it is giving me an "invalid option name SELECT" error.

proc export data = Data.master_After2001WithGPA (select=(studentID, Gender, GPA))
dbms = xls
outfile = "/folders/myfolders/Question6_Output.xls"
replace;

run;

Re: Exporting to Excel Spreadsheet

unison — Fri, 24 Jan 2020 04:09:51 GMT

the correct syntax is keep= as opposed to select=. Also remove the commas in the field list