topic Re: Checking a Variable from a Macro variable list in SAS Programming

Checking a Variable from a Macro variable list

dennis_oz — Tue, 12 May 2020 02:18:20 GMT

Hi ,

Can someone suggest how to do the below.

have :

Table1;

Column1

AAAA

AAAE

AAAX

Want:

if 'AAAA' in Column1 then do %process1;

else if 'AAAE' in Column1 then do %process2;

else if 'AAAX' in Column1 then do %process3;

else %process4 ;

Re: Checking a Variable from a Macro variable list

RichardDeVen — Tue, 12 May 2020 02:36:34 GMT

Presuming the DATA step is simply dispatching macros that perform other steps, and do not need to feedback to the running DATA step...

Use either

doSubL() function, or
CALL EXECUTE routine

Example:

%NRSTR is used to stack all invocations until DATA step finishes.

data _null_;
  set have;
  select (Column1);
    when ('AAAA') call execute ('%nrstr(%process1))');  /* or rc=dosubl('%process1'); */
    when ('AAAE') call execute ('%nrstr(%process2))');  /* or rc=dosubl('%process2'); */
    when ('AAAX') call execute ('%nrstr(%process3))');  /* or rc=dosubl('%process3'); */
    otherwise     call execute ('%nrstr(%process4))');  /* or rc=dosubl('%process4'); */
  end;
run;

Re: Checking a Variable from a Macro variable list

ChrisNZ — Tue, 12 May 2020 03:40:01 GMT

If the macros contain data step statements, then this is a possible syntax:

if      COLUMN1='AAAA' then do; %process1; end;
else if COLUMN1='AAAE' then do; %process2; end;
else if COLUMN1='AAAX' then do; %process3; end;
else                        do; %process4; end;