Skip to content

Instantly share code, notes, and snippets.

@rkoopmann

rkoopmann/expExcel.sas

Created February 27, 2015 21:02
Show Gist options
  • Save rkoopmann/c3ffd2ed1fa618b214c6 to your computer and use it in GitHub Desktop.
Save rkoopmann/c3ffd2ed1fa618b214c6 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
expExcel.sas
%macro expExcel(
data
, path=c:\temp\
, file=%scan(&DATA,1,'.')
, sheet=%scan(&DATA,2,'.')
);
proc export
data=&DATA.
outfile="&PATH.\&FILE..xls"
dbms=excel
replace;
sheet=&SHEET;
run;
%mend expExcel;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment