Re-coding to dates

[mmyrto]

I have a variable date with values month1-month38 and i want to recode them to 1/1/2012-1/1/2015. Is there an easy way to do this? Using array maybe?

[ballardw · Accepted solution]

If the current value is actually month1 then the current variable is text. Do you want an actual SAS date valued variable (recommended) or a text string.

If month1 represents Jan 2012 then something like:

newdate = intnx('Month','01JAN2012'd,(input(substr(date,6),best2.) -1),'BEGINNING');

FORMAT newdate mmddyy10.;

[mmyrto]

Thanks this is exactly what i was looking for!