https://communities.sas.com/t5/SAS-Enterprise-Guide/Convert-character-string-to-date9/m-p/462121#M29796 <P>Use the YYQ informat:</P> <PRE><CODE class=" language-sas">numvar = input(charvar,yyq6.); format numvar date9.;</CODE></PRE> Mon, 14 May 2018 16:38:16 GMT Kurt_Bremser 2018-05-14T16:38:16Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Convert-character-string-to-date9/m-p/462116#M29795 <P>Hello,&nbsp;</P><P>&nbsp;</P><P>Somehow my dates were input into my dataset wrong and I need to change them.</P><P>&nbsp;</P><P>I have the dates as a string right now and they are in yyq6. format but in characters. So the current dates show 2017Q1, 2017Q2, etc. but are char$6 as a string.</P><P>&nbsp;</P><P>What I want is to see 01JAN2017 for the string 2017Q1, 01APR2017 for the string 2017Q2 and so on. But not just a string of that - it needs to be a proper date format.</P><P>&nbsp;</P><P>I feel like I have tried everything and at best it will error out and at worst it will set all of values for that variable to missing.</P><P>&nbsp;</P><P>How can I do this??</P><P>&nbsp;</P><P>Thank you for your help!!</P> Mon, 14 May 2018 16:21:16 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Convert-character-string-to-date9/m-p/462116#M29795 amylanza 2018-05-14T16:21:16Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Convert-character-string-to-date9/m-p/462121#M29796 <P>Use the YYQ informat:</P> <PRE><CODE class=" language-sas">numvar = input(charvar,yyq6.); format numvar date9.;</CODE></PRE> Mon, 14 May 2018 16:38:16 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Convert-character-string-to-date9/m-p/462121#M29796 Kurt_Bremser 2018-05-14T16:38:16Z