%if -%else statement: %else does not output results

[RubenPloeg]

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;

[Jagadishkatam · Accepted solution]

could you please try replacing the &cnt ne 0 with &cnt > 0

     %if &cnt > 0 %then %do;

           proc print data=DATA_REPORT;

                title "...";

           run;

     %end;

 

     %else %do;

           data _null_;

                title "...";

                file print;

                put _page_;

                put "...";

           run;

     %end;