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;
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;
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;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.