topic Re: Re-coding to dates in SAS Programming https://communities.sas.com/t5/SAS-Programming/Re-coding-to-dates/m-p/194057#M36488 <HTML><HEAD></HEAD><BODY><P>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.</P><P>If month1 represents Jan 2012 then something like:</P><P></P><P>newdate = intnx('Month','01JAN2012'd,(input(substr(date,6),best2.) -1),'BEGINNING');</P><P>FORMAT newdate mmddyy10.;</P></BODY></HTML> Wed, 27 May 2015 15:08:27 GMT ballardw 2015-05-27T15:08:27Z Re-coding to dates https://communities.sas.com/t5/SAS-Programming/Re-coding-to-dates/m-p/194056#M36487 <HTML><HEAD></HEAD><BODY><P>I have a variable <EM>date</EM> 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?</P></BODY></HTML> Wed, 27 May 2015 14:47:01 GMT https://communities.sas.com/t5/SAS-Programming/Re-coding-to-dates/m-p/194056#M36487 mmyrto 2015-05-27T14:47:01Z Re: Re-coding to dates https://communities.sas.com/t5/SAS-Programming/Re-coding-to-dates/m-p/194057#M36488 <HTML><HEAD></HEAD><BODY><P>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.</P><P>If month1 represents Jan 2012 then something like:</P><P></P><P>newdate = intnx('Month','01JAN2012'd,(input(substr(date,6),best2.) -1),'BEGINNING');</P><P>FORMAT newdate mmddyy10.;</P></BODY></HTML> Wed, 27 May 2015 15:08:27 GMT https://communities.sas.com/t5/SAS-Programming/Re-coding-to-dates/m-p/194057#M36488 ballardw 2015-05-27T15:08:27Z Re: Re-coding to dates https://communities.sas.com/t5/SAS-Programming/Re-coding-to-dates/m-p/194058#M36489 <HTML><HEAD></HEAD><BODY><P>Thanks this is exactly what i was looking for!</P></BODY></HTML> Wed, 27 May 2015 15:14:36 GMT https://communities.sas.com/t5/SAS-Programming/Re-coding-to-dates/m-p/194058#M36489 mmyrto 2015-05-27T15:14:36Z