I am trying to set up a report with the input dates always today and 1 week back. I am able to get these macro variables into the correct form as strings, but when I go to try to use them in a sql query (below) the fact that they are strings causes an error. I have thought about just using a data step and changing the format in the datastep, but for this particular query a datastep takes forever. Any suggestions would be very helpful.
73 %let end_date_value =%sysfunc(today());
74 %put &end_date_value;
18003
75
76 %let start_date_value = %eval(&end_date_value-7);
77 %put &start_date_value;
17996
78
79 %let start_date = %sysfunc(putn(&start_date_value, date9.));
80 %put &start_date;
09APR2009
81
82 %let end_date = %sysfunc(putn(&end_date_value, date9.));
83 %put &end_date;
16APR2009
proc sql;
create table P as
select *
from table as rt
where date >= &start_date
and date <= &end_date
;
quit;
... View more