The code below works fine. The output file is the same as the input with 'TBL_' added as a name prefix. However, when I try to append '_TBL' as a suffix, rather than prefix, the step fails thinking that the '_TBL' is part of the macro variable name. %MACRO PREP_TBL; %DO I = 1 %TO 3 ; DATA TBL_&&TBL&i|' ; SET &&TBL&i ; WHERE DATE_ID GE 20160701 AND DATE_ID LE 20180630 ; RUN; %END ; %PREP_TBL ; %MEND;
... View more