topic Re: how to pass all the values of a table to a macro in SAS Programming

how to pass all the values of a table to a macro

kumarK — Sun, 14 Dec 2014 11:12:48 GMT

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.

Ksharp — Sun, 14 Dec 2014 11:21:09 GMT

proc sort data=have(keep=country) out=country nodupkey;by country;run;

data _null_;

set country;

call execute('%mymacro(country=' ||country|| ')' );

run;

Xia Keshan

kumarK — Sun, 14 Dec 2014 12:06:09 GMT

Thanks for your reply Xia Keshan,

I am getting one error. Is there anything i am missing in below code?

data test;

set sashelp.class;

run;

data name_list;

input names$;

cards;

Alfred

Henry

John

Ronald

run;

%macro mymac(a);

proc print data=test;

where name = &a;

run;

%mend;

data _null_;

set name_list;

call execute('%mymac('||names||')');

run;

Ksharp — Sun, 14 Dec 2014 13:06:13 GMT

Yeah.

%macro mymac(a);

proc print data=test;

where name = "&a";

run;

%mend;