I need to create 'put' statements in order to get '01/01/previous year' and '12/31/previous year' for a program that is run on an annual basis so I don't need to manually change the year.
My sql code in the proc sql is this:
AND EFF_DT <= '12/31/2013'
AND (TRM_DT BETWEEN '01/01/2013' AND '12/31/2013'
OR TRM_DT IS NULL)
This is also inside a macro and I'm not sure once I get the dates for the 'put' statement, what I need to change the hard coded dates to in order for the query to work.