topic Re: Create a macro variable with condition in SAS Programming

Create a macro variable with condition

Ronein — Mon, 02 Aug 2021 07:01:04 GMT

Hello

I want to create a macro variable called FromDate that will get the following value:

IF data set ttt exists then it will get value of max(BirthDate)

IF data set ttt doesn't exist then it will get value 22158 (Which represent 31Aug2020)

What is the way to do it please?

The code below is not working well, since data set ttt exists I expect to get value 22428 but I get value 22158.

Why?


data ttt;
input BirthDate : date9.;
cards;
15Aug2020'd
28MAY2021'd
;
Run;

%macro RRR;
%if %sysfunc(exist(ttt)) %then %do;
PROC SQL noprint;
select  max(BirthDate) into : FromDate	   
from  ttt
;
QUIT;
%end;
%else %do;
data _null_;
call symputx('FromDate','22158');
run;
%end;
%mend RRR;
%put &FromDate;

Re: Create a macro variable with condition

andreas_lds — Mon, 02 Aug 2021 07:09:20 GMT

untested

%macro narf;
  %global FromDate;
  %if %sysfunc(exist(work.ttt)) %then %do;
    proc sql noprint;
      select max(BirthDate) into :FromDate trimmed
        from work.ttt;
    quit;
  %end;
  %else %do;
    %let FromDate = '31Aug2020'd;
  %end;
%mend;

Re: Create a macro variable with condition

ballardw — Mon, 02 Aug 2021 07:36:38 GMT

Where is this macro variable to be used?

You may run into scope issues of where this is defined not being available to where actually wanted.

Re: Create a macro variable with condition

Ronein — Mon, 02 Aug 2021 07:47:54 GMT

What is wrong with my code?

Re: Create a macro variable with condition

Astounding — Mon, 02 Aug 2021 08:11:25 GMT

Three places to begin...
Does your program actually call the macro? I would expect to see this statement: %rrr
Second, for testing purposes, simplify the macro down to a one line version. After creating ttt:
%macro rrr2;
%put %sysfunc(exist(ttt));
%mend rrr2;
%rrr2
Third, is your post showing the actual definition of %rrr or a simplified version? We need to see the actual first line (%macro %rrr statement).