topic Converting text to date format in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/Converting-text-to-date-format/m-p/163247#M42364 <HTML><HEAD></HEAD><BODY><P><BR />I have a text variable called transaction date&nbsp; which has values like 01-APR-14. I want to convert this variable to a date variable in the format ddmmyy.</P><P></P><P>I have used the code</P><P></P><P><STRONG style=": ; color: #008080; font-size: 10pt; font-family: Consolas;">date=input(substr(strip(transaction_date),1,9),MMDDYY10.)</STRONG></P><P></P><P><SPAN style="color: #000000; font-size: 10pt; font-family: arial,helvetica,sans-serif;">This doesn't seem to work. Can anyone suggest how to do this.</SPAN></P></BODY></HTML> Sat, 17 May 2014 18:39:53 GMT ranjita 2014-05-17T18:39:53Z Converting text to date format https://communities.sas.com/t5/SAS-Procedures/Converting-text-to-date-format/m-p/163247#M42364 <HTML><HEAD></HEAD><BODY><P><BR />I have a text variable called transaction date&nbsp; which has values like 01-APR-14. I want to convert this variable to a date variable in the format ddmmyy.</P><P></P><P>I have used the code</P><P></P><P><STRONG style=": ; color: #008080; font-size: 10pt; font-family: Consolas;">date=input(substr(strip(transaction_date),1,9),MMDDYY10.)</STRONG></P><P></P><P><SPAN style="color: #000000; font-size: 10pt; font-family: arial,helvetica,sans-serif;">This doesn't seem to work. Can anyone suggest how to do this.</SPAN></P></BODY></HTML> Sat, 17 May 2014 18:39:53 GMT https://communities.sas.com/t5/SAS-Procedures/Converting-text-to-date-format/m-p/163247#M42364 ranjita 2014-05-17T18:39:53Z Re: Converting text to date format https://communities.sas.com/t5/SAS-Procedures/Converting-text-to-date-format/m-p/163248#M42365 <HTML><HEAD></HEAD><BODY><P>Assuming transaction_date is a character the following is what you want:</P><P>date=input(strip(transaction_date), date9.);</P><P>format date mmddyy10.;</P></BODY></HTML> Sat, 17 May 2014 18:49:52 GMT https://communities.sas.com/t5/SAS-Procedures/Converting-text-to-date-format/m-p/163248#M42365 Reeza 2014-05-17T18:49:52Z