Run Proc Sql base on conditions

scb — Tue, 07 Aug 2018 10:11:21 GMT

I tried to run the below codes but it won't execute, anyone can help? Many thanks.

data test;
input rptinput $;
cards;
Report1
;
run;

proc sql noprint;
select distinct rptinput
into :REPORT separated by ''
from test;
quit;
%put &report;

%macro condtest;
%if &report eq "Report1" %then %do;
proc sql;
select * from Sashelp.shoes;
%end;
%else %if &report eq "Report2" %then %do;
proc sql;
select * from Sashelp.cars;
;
%end;
%mend condtest;
quit;

%condtest
quit;

Re: Run Proc Sql base on conditions

RW9 — Tue, 07 Aug 2018 10:29:03 GMT

Format your code and you will note where additional things are not needed. The cause of your issue is that the macro call is not finished with a ; - always ensure you finish things correctly, end of statemetns with semi colon, end of macro variables with a dot etc.

data test;
input rptinput $;
cards;
Report1
;
run;

proc sql noprint;
  select distinct rptinput
  into :REPORT separated by ''
  from test;
quit;

%macro condtest;
  proc sql;
  %if "&report." eq "Report1" %then %do;
    select * from Sashelp.shoes;
  %end;
  %else %if "&report." eq "Report2" %then %do;
    select * from Sashelp.cars;
  %end;
  quit;
%mend condtest;

%condtest;

topic Re: Run Proc Sql base on conditions in SAS Programming

Run Proc Sql base on conditions

Re: Run Proc Sql base on conditions