I use SAS to create 3 data sets. then I use PROC PRINT per the code below to create 3 excel files which show their data. Is there anyway to make a statement that puts all 3 data sets as diffferent tabs in the same excel file???
ods excel file='D:\qsilver\SAS Data\BZ\3_Output\TotalOutput5k.xlsx' style=meadows;
Proc print data=work.histodata_Total noobs label;
run;
ods excel close;
ods excel file='D:\qsilver\SAS Data\BZ\3_Output\RefiOutput5k.xlsx' style=meadows;
Proc print data=work.histodata_refi noobs label;
run;
ods excel close;
ods excel file='D:\qsilver\SAS Data\BZ\3_Output\PurchaseOutput5k.xlsx' style=meadows;
Proc print data=work.histodata_purchase noobs label;
run;
ods excel close;
One way is via the XLSX engine:
libname xlout XLSX 'D:\qsilver\SAS Data\BZ\3_Output\Output5k.xlsx'; data xlout.Total; set work.histodata_Total; run; data xlout.Refi; set work.histodata_Refi; run; data xlout.Purchase; set work.histodata_Purchase; run; libname xlout clear;
See Chris' blog post for more details: Using LIBNAME XLSX to read and write Excel files
One way is via the XLSX engine:
libname xlout XLSX 'D:\qsilver\SAS Data\BZ\3_Output\Output5k.xlsx'; data xlout.Total; set work.histodata_Total; run; data xlout.Refi; set work.histodata_Refi; run; data xlout.Purchase; set work.histodata_Purchase; run; libname xlout clear;
See Chris' blog post for more details: Using LIBNAME XLSX to read and write Excel files
Genius! Exactly what I needed, thank you!!!
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.