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
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.