Hi all,
Lets say I have 3 data sets:
Data1, Data2, Data3
and I want to export it to a excel file called AllData
And have 3 sheets: Data1 (containing all the information from Data1), Data2, Data3.
Is this possible?
Thanks!
You can use proc export or ODS:
proc export data=table1 out="path/filename.xlsx" dbms=xlsx replace; sheet="sheet_name1";run;
proc export data=table2 out="path/filename.xlsx" dbms=xlsx replace; sheet="sheet_name2";run;
proc export data=table3 out="path/filename.xlsx" dbms=xlsx replace; sheet="sheet_name3";run;
Remember to have same output file name otherwise will create different files.
You can also use the Excel LIBNAME engine and PROC DATASETS.
Libname outXL XLSX 'path to excel file.xlsx'; Proc datasets library=work nodetails nolist; Copy in=work out=outXL; Select data1-data3; Run;quit; Libname outXL;
If on SAS 9.4 M3 you can also use ODS EXCEL
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.