topic Re: Check if Date prompt macro exist in SAS Enterprise Guide

Check if Date prompt macro exist

TT_T — Wed, 08 Aug 2018 09:55:05 GMT

I´m getting a date(Name: start) over a prompt and i dont know, if symexist work on dates, because i have some problems...

%macro test;
    %global Var;
        %if %symexist(start) = 1 %then %do;
            %let Var = startdate is DATE(%bquote('&start'));;
            %end;
        %else %if %symexist(start)= 0 %then %do;
        %let Var= no startdate;
        %end;
%mend;

Edit:

%if %symexist(start) = 1 and %sysevalf(%superq(start)=,boolean) = 0 %then %do;

%if %symexist(start) = 1 and %sysevalf(%superq(start)=,boolean) = 1 %then %do;

That solved it.

Re: Check if Date prompt macro exist

ballardw — Wed, 08 Aug 2018 16:34:02 GMT

Your "that solved" implies that the prompt existed but for some reason there was no value assigned in some cases I believe.

Re: Check if Date prompt macro exist

TT_T — Thu, 09 Aug 2018 06:39:59 GMT

Right. The title is wrong -> check if prompt is empty or not would be better.

So %sysevalf(%superq(start)=,boolean).