Generating 2 Data Files with a Macro using Conditional Logic

Question

I'm trying to create 2 data files with a macro using conditional logic (I know there are other methods to generate these 2 files).

%MACRO SelectCount;

%if GenderID = 2 %then %do;

Data female200;
set cd4;
if Count<200 and count ne . and Prescribed1=2 and Prescribed2=1;        
run;
%end;

%else %if GenderID=1 %then %do;

Data male200;
set cd4;
if Count<200 and count ne . and and Prescribed1=2 and Prescribed2=1;        
run;

%end;
%MEND SelectCount;

%SelectCount;

proc print data=female200 (obs=20); Title3 'Females'; run;

proc print data=male200 (obs=20); Title3 'Males'; run;

I'm getting an error that the female200 and male200 data do not exist.

Answer 1

KwonC, is "GenderID" a macro variable or a dataset variable? If it is a macro variable, then you need to preface it with an ampersand in the %IF/%ELSE %IF statements, such as "IF &GenderID = 1 %THEN %DO;". If it is instead a dataset variable within the CD4 dataset then you could get rid of the macro code and rewrite the program like the following:

DATA female200 male200;
   IF (count < 200) AND
      (count NE .) AND
      (Prescribed1 = 2) AND
      (Prescribed2 = 1);
   IF (GenderID = 1) THEN OUTPUT male200;
   ELSE IF(GenderID = 2) THEN OUTPUT female200;
RUN;

If GenderID is a macro variable, then you will still have an issue, even after adding the ampersand prefix. Since you have only called the %SelectCount one time, one of the two result datasets will not have been created, so you will still have an error in the log file when you try to print the other one. A simple fix would be to move the PRINT procedures into the %IF/%ELSE %IF sections of your macro definition.

Generating 2 Data Files with a Macro using Conditional Logic

Follow this question

Related questions