hi all,
Can i have more macro codes written within one and then by callin the main one i can execute all?
Also,i have a dataset out of each i am supposed to run 10 queries.Can I write a macro that would export the results of all these 10 queries into one workbook of excel?
Not all of the 10 queries have the same column names.And if macro cant,can i do the same then without macro?
I am need to have the results of all the queries on one workbook so i can easily populate some tables in excel
Please anyone
A macro can call anything you want it to.
%macro big ;
%small1;
%small2;
%mend big;
Look at using ODS TAGSETS.EXCELXP to generate output into multiple sheets of an excel file.
sorry i meant to ask if i can have sas export the results of all the queries onto one worksheet but i guess that s not possible.
Thanks Tom
Yes you can, but you'll have different tables is all, they won't stack up.
ods tagsets.excelxp file="c:\temp\test.xls";
proc print data=sashelp.class;
run;
proc print data=sashelp.cars;
run;
ods tagsets.excelxp close;
will try this today
Thanks Reeza
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.