topic Re: using an iterative do loop for a macro in SAS Programming

using an iterative do loop for a macro

Emma_at_SAS — Mon, 08 Mar 2021 20:47:54 GMT

Hello,

I have a macro for serveyfreq that I would like to repeat for 4 levels of &var_name. Therefore I added

%do i=1 %to i=4; ....end (vane_name is a numerical variable); The macro runs well without the do loop but not with the do loop. I appreciate your suggestions to resolve this issue.

* without do loop;

%macro posthoc(var_name);

proc surveyfreq data = data_have VARHEADER = NAMELABEL nosummary;
tables gender/ testp=(50 50) nostd row row(cl) cv chisq;
where &var_name = 1 and condition=1;
weight weight_resc;
run;
quit;

mend posthoc;

* with do loop;

%macro posthoc(var_name);

%do i=1 %to i=4;

proc surveyfreq data = data_have VARHEADER = NAMELABEL nosummary;
tables gender/ testp=(50 50) nostd row row(cl) cv chisq;
where &var_name = 1 and condition=1;
weight weight_resc;
run;

end;
quit;

mend posthoc;

Thanks

Re: using an iterative do loop for a macro

Reeza — Mon, 08 Mar 2021 20:52:05 GMT

Why not just use a BY statement instead?

proc surveyfreq data = data_have VARHEADER = NAMELABEL nosummary;
by var_name;
tables gender/ testp=(50 50) nostd row row(cl) cv chisq;
where condition=1;
weight weight_resc;
run;
quit;

Re: using an iterative do loop for a macro

Emma_at_SAS — Mon, 08 Mar 2021 22:54:13 GMT

Thanks, Reeza. That was a good idea! I wanted to use two loops for both var_name and condition. Now, I need only one do loop. Would you please help me to figure this out?

Re: using an iterative do loop for a macro

Reeza — Mon, 08 Mar 2021 23:10:53 GMT

Or add two variables to your BY statement instead.

proc surveyfreq data = data_have VARHEADER = NAMELABEL nosummary;
by var_name condition;
tables gender/ testp=(50 50) nostd row row(cl) cv chisq;
where condition=1;
weight weight_resc;
run;

@Emma_at_SAS wrote:

Thanks, Reeza. That was a good idea! I wanted to use two loops for both var_name and condition. Now, I need only one do loop. Would you please help me to figure this out?

Re: using an iterative do loop for a macro

Emma_at_SAS — Tue, 09 Mar 2021 18:39:58 GMT

Thank you! Yes, that worked!