Is there a way to insert a prompt in your where statement to filter for the date. Below is the code the way I tried it, but it doesn't work.   proc print data=SOMEDATA; where datepart(error_dt) > '&date'; run;   Where error_dt is a date variable. ... View more

The following code gives output if the %if-statement is true, but does not give an output if the %else statement is true. Does anyone know what is going wrong here?      %if &cnt ne 0 %then %do;            proc print data=DATA_REPORT;                 title "...";            run;      %end;        %else %do;            data _null_;                 title "...";                 file print;                 put _page_;                 put "...";            run;      %end;     ... View more