12-14-2014 06:12 AM
i have a macro it will take input as a country and will give its population.
Then i have another table list of all countries. I want to pass all these countries to that macro.
I tried below way i declared all the countries in a global variable and passed that variable
% let countries=india nepal......;
This is not a efficient way. how can i pass all the values of another table in to that macro. Please throw some inputs.
12-14-2014 06:21 AM
proc sort data=have(keep=country) out=country nodupkey;by country;run;
call execute('%mymacro(country=' ||country|| ')' );
12-14-2014 07:06 AM
Thanks for your reply Xia Keshan,
I am getting one error. Is there anything i am missing in below code?
proc print data=test;
where name = &a;
Need further help from the community? Please ask a new question.