Hello,
I used 4 sql procedures to create 4 tables, and i want to export all this tables in a single excel file but i don't know how !!
is there any thing to merge my 4 table (many colomnes and one row in all of it) before exporting ? if not, how can export it in one excel file ?
If you want to use proc export you can do this way.,
Proc export data= dataset
outfile="location and file name.xlsx"
dbms=xlsx replace; sheet='sheetname';run;
Giving a different sheetname for every new export statement is importnat so it doesnot override the previous one.
repeat this procedure for any number of datasets.. !
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: