topic Re: Base sas do while query in SAS Data Management

Base sas do while query

sas_learnsups — Fri, 12 Apr 2019 02:23:12 GMT

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!

Re: Base sas do while query

Kurt_Bremser — Fri, 12 Apr 2019 05:37:51 GMT

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

Re: Base sas do while query

andreas_lds — Fri, 12 Apr 2019 06:44:47 GMT

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;

Re: Base sas do while query

sas_learnsups — Fri, 12 Apr 2019 06:47:18 GMT

Many thanks. Will check and let you know

Re: Base sas do while query

Astounding — Fri, 12 Apr 2019 08:00:47 GMT

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.