i have a macro that runs a seq for every day of a month here is the ode with the table ....how do I make it to where table one actually runs for every day % macro run code (today); %include "a:\password.sas"; proc sql: cconnect to odbc (datasrc ='prod' user=******* password=*******); create table one as select * from connection to odbc ( select id, admin_dat from table where admin_dat= &td. ); quit; %mend; %macro runmail; %do i=1 %to 30; data _null_; call symputx('td'," ' " ||put (mdy(4,&i.,2015),date.)||" 'd "); run; %put &td.; %end; %mend; %runall;
... View more
