Base sas do while query

[sas_learnsups]

Hi all,

I have to check character values across 50 variables.I am using datastep where i am outp only those records who have the values. but getting error.

The program i am trying is somewht like this:

data test1;
set test;
do i=1 to 50 by 1;
if diagnosis_code&i like 'E10%' then output;
end;
run;

The dataset is huge like 19+ million records.(Can't think of transpose)

Thanks a lot in advance!

[Kurt_Bremser]

You need to define an array over your variables, and loop through that.

[andreas_lds]

You want the observations having the diagnosis-code only once even if diagnosis_code1 and diagnosis_code4, for example, have "E10%"?

untested:

data want;
  set test;
  array codes[50] diagnosis_code1-diagnosis_code50;
  
  do i = 1 to dim(codes);
    if codes[i] like 'E10%' then do;
      output;
      leave;
    end;
  end;
run;

[sas_learnsups]

Many thanks. Will check and let you know

[Astounding · Accepted solution]

I suspect you will have trouble with:

if codes[i] like 'E10%' then do;

If that's the case, switch to:

if codes[i] =: 'E10' then do;

Don't forget the colon after the equal sign. That's intentional and not a typo.