topic how to iterate %do loop over uneven intervals of index values in SAS Programming

how to iterate %do loop over uneven intervals of index values

chaitanya — Mon, 17 Feb 2014 14:37:35 GMT

data x ;

set % do i = 1 , 2 , 3 , 8 , 10 ;

xyz&i

%end; ;

run;

Hi guyz, I need to append some datasets which ends with a number like this scenario above. But , when i run this code am getting this error "%to note found, macro is not compiled" . Please help me in this situation

Re: how to iterate %do loop over uneven intervals of index values

Tom — Mon, 17 Feb 2014 14:44:38 GMT

%DO is not as flexible as DO.

Make a list and loop over an index into the list.

Note: the %UNQUOTE() is because sometimes the parser can get confused by this type of syntax and treat the XYZ and %SCAN() as separate tokens.

%let suffix=1 2 3 8 10;

data x ;

set

%do i=1 %to %sysfunc(countw(&suffix,%str( )));

%unquote(xyz%scan(&suffix,&i,%str( )))

%end;

;

run;