%macro runner(yy=);
proc import datafile="E:\Idaho\ID&yy..txt"
dbms=dlm out=work.test;
delimiter =",";
getnames=yes;
guessingrows=100000;
run;
data Work.ID&yy.ay;
set test;
Inspection_year=&yy.;
run;
proc export data=Work.ID&yy.ay replace
outfile = "E:\Ad_Year\ID&yy.ay" /* or do you want the output file to be Text use this Outfile = "E:\Ad_Year\ID&yy.ay.txt" */
dbms=dlm;
delimiter=',';
run; proc datasets lib=work; delete test; quit;
%mend runner;
%runner(yy=1992);
%runner(yy=1993);
.
.
%runner(yy=2017);
Thank you @Reeza for the eagle eye added a delete.
... View more
