topic Re: Macro %do loop start in SAS Programming

Macro %do loop start

Toni2 — Tue, 05 Jul 2022 09:47:46 GMT

I am trying to start the loop in %do expression to be equal to start_id =227

i use the % SYSEVALF(&start_id.) however, does not work

i want the proc hpbin to have in the WHERE statement the i which should take the values from start_id to end_id

%let start_id=227;
%let end_id=290;

%macro IV_continuous(ds=,vars=,bad=);
                                                                                                 
%let yy=%SYSEVALF((&end_id.-&start_id.)+1);

%do i=%SYSEVALF(&start_id.) %to &yy. ;
 
proc hpbin data = &ds. numbin = 10;
		input &vars.;
		where monthid = &i;
		ods output mapping = bin_&i.;
	run;

%end;
%mend;

%IV_continuous(ds=pd_data.upl_test,vars=&varcon,bad=bad);

Re: Macro %do loop start

Kurt_Bremser — Tue, 05 Jul 2022 09:53:07 GMT

Run this:

%let start_id=227;
%let end_id=290;
%let yy=%SYSEVALF((&end_id.-&start_id.)+1);
%put &=yy.;

Then manually insert the values into your %DO, and you'll see it resolves to this:

%do i = 227 %to 64;

which means the loop will never execute.

Either run it from &start_id to %end_id, or from 1 to &yy.

Re: Macro %do loop start

Toni2 — Tue, 05 Jul 2022 10:34:54 GMT

great! thanks