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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.