topic Non continous do loop in SAS Programming

Non continous do loop

SASPhile — Wed, 11 Sep 2013 19:50:09 GMT

I want to skip iteration 19.

The following doesnt seem to work.

%macro zz;

data sasdata.som_all;

      set %do i = 10 %to 18, 20 %to 23;
           sasdata.som&i.
           %end;;
     run;
     %mend zz;
     %zz;

Re: Non continous do loop

Jakkas — Wed, 11 Sep 2013 19:57:28 GMT

How about

%macro zz;

data sasdata.som_all;

set %do i = 10 %to 23;

               %IF &i NE 19 %Then sasdata.som&i.;
           %end;;
     run;
%mend zz;

Re: Non continous do loop

Peter_C — Sat, 14 Sep 2013 07:17:11 GMT

have a look at http://communities.sas.com/ideas/1084 a ballot item which seems most relevant to your question. See the comment on 18-May-2013.

Re: Non continous do loop

data_null__ — Sat, 14 Sep 2013 13:52:37 GMT

Of course this is the same as program but I bit more general "to me". For lists of data set you don't even need the macro you could write set som10-som18 some20-some24; And as mentioned there is the effort to get the syntax of the more robust DO applied to the %DO. I think we've been waiting on that since 1982.

data som10 som12 som14;
   x=1; 
   run; 
%macro zz; 
   %local i skip;
   %let skip = 13,11;
   data som_all;
      set 
      %do i = 10 %to 14; 
         %if %sysfunc(whichn(&i,&skip)) %then %goto continue;
         som&i.
       %continue: %end; 
       ;
     run;
   %mend  zz;
options mprint=1; 
%zz;

Re: Non continous do loop

Peter_C — Sat, 14 Sep 2013 22:25:52 GMT


we've been waiting on that since 1982.

we have enough in the macro language

"gild the lily" comes to mind (a half-remembered version of Shakespeare :)