topic IF-THEN-ELSE without conditions for THEN in SAS Programming

IF-THEN-ELSE without conditions for THEN

Anna_dlC — Tue, 12 Jun 2018 13:27:20 GMT

I have this long-running macro code to check for the existence of a local table but there are no statements after the THEN. What happens? What does SAS do? I'm just trying to understand the logic

/* make sure the local table exist */

%if %sysfunc(exist(cdm.&tablename)) %then;

%else %do;

%let man_month=%sysfunc(putn(%sysfunc(intnx(MONTH,%sysfunc(inputn(&sysdate9,date9.)),+1)),yymmn6.));

%return;

%end;

Re: IF-THEN-ELSE without conditions for THEN

PaigeMiller — Tue, 12 Jun 2018 13:34:58 GMT

If this macro finds that the table exists, it does nothing. If it does not exists then it does the calculation in the %ELSE portion.

Re: IF-THEN-ELSE without conditions for THEN

gamotte — Tue, 12 Jun 2018 13:46:16 GMT

A more readable version would be to simply negate the condition :

%if not %sysfunc(exist(cdm.&tablename)) %then do;  
    %let man_month=....
%end;