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
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: