topic Re: SAS dates from Character Strings in SAS Programming https://communities.sas.com/t5/SAS-Programming/SAS-dates-from-Character-Strings/m-p/209216#M38821 <HTML><HEAD></HEAD><BODY><P>Use the INPUT function so that you can use an INFORMAT to convert the value for you.</P><P></P><P>mydate = input(mystring,date11.);</P><P>format mydate date9. ;</P></BODY></HTML> Tue, 24 Mar 2015 17:41:40 GMT Tom 2015-03-24T17:41:40Z SAS dates from Character Strings https://communities.sas.com/t5/SAS-Programming/SAS-dates-from-Character-Strings/m-p/209215#M38820 <HTML><HEAD></HEAD><BODY><P><BR />I have a character string '03-jul-95' that has a format of $255. and an informat of $255.&nbsp;&nbsp; I want to convert this to a SAS date.&nbsp;&nbsp; I know how to substring the individual components but I don't know how to convert 'jul' to month number to use the MDY function.&nbsp; I would appreciate any assistance I can get.&nbsp;&nbsp; Thanks,</P></BODY></HTML> Tue, 24 Mar 2015 17:14:37 GMT https://communities.sas.com/t5/SAS-Programming/SAS-dates-from-Character-Strings/m-p/209215#M38820 Kim_SOM 2015-03-24T17:14:37Z Re: SAS dates from Character Strings https://communities.sas.com/t5/SAS-Programming/SAS-dates-from-Character-Strings/m-p/209216#M38821 <HTML><HEAD></HEAD><BODY><P>Use the INPUT function so that you can use an INFORMAT to convert the value for you.</P><P></P><P>mydate = input(mystring,date11.);</P><P>format mydate date9. ;</P></BODY></HTML> Tue, 24 Mar 2015 17:41:40 GMT https://communities.sas.com/t5/SAS-Programming/SAS-dates-from-Character-Strings/m-p/209216#M38821 Tom 2015-03-24T17:41:40Z Re: SAS dates from Character Strings https://communities.sas.com/t5/SAS-Programming/SAS-dates-from-Character-Strings/m-p/209217#M38822 <HTML><HEAD></HEAD><BODY><P>Thank you so much for the quick reply.&nbsp; I do appreciate it</P></BODY></HTML> Tue, 24 Mar 2015 17:47:25 GMT https://communities.sas.com/t5/SAS-Programming/SAS-dates-from-Character-Strings/m-p/209217#M38822 Kim_SOM 2015-03-24T17:47:25Z