12-03-2016 03:49 PM
Here is what i need help into.
I have two macro definations
Macro1 and Macro2
and they have macro calls as
Both macro1 and macro2 have proc sql statement within them and output a 2 column 2 row output(1st row headers,which are differant for each macro call and second rows are numeric values.)
I want to append all results of macro calls(for both tables) into a SAS dataset.Please help me on this.Thanks!
12-03-2016 08:10 PM
Here are two options.
Make each macro generate an output table with a unique name and then appemd the results. Use a naming convention, such as a common prefix so that you can use either a colon or list to append all easily.
set result1-result10;*appends all tables in between result1, result2, etc;
Set result:; *will append any table starting with the work result;
Or have each iteration of the macro append the results to a main result table. If you rerun a section you'll end up,with duplicate results so would need to manage that.
For this option look at PROC appemd.
12-03-2016 08:26 PM
12-03-2016 08:27 PM
Hi..thanks for reply,here is what i am trying to do now....i generated tables with differant names....