Desktop productivity for business analysts and programmers

Check if Date prompt macro exist

Reply
Occasional Contributor
Posts: 6

Check if Date prompt macro exist

[ Edited ]

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.

Super User
Posts: 13,941

Re: Check if Date prompt macro exist

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

 

 

Occasional Contributor
Posts: 6

Re: Check if Date prompt macro exist

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

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

Ask a Question
Discussion stats
  • 2 replies
  • 79 views
  • 0 likes
  • 2 in conversation