topic Re: Character Year-Mon to Number Mon-Year in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/Character-Year-Mon-to-Number-Mon-Year/m-p/178582#M45591 <HTML><HEAD></HEAD><BODY><P>data want;<BR />&nbsp; set have;<BR />&nbsp; date_need=input(date_have,anydtdte7.);<BR />&nbsp; format date_need monyy7.;<BR />&nbsp; run;</P></BODY></HTML> Mon, 14 Jul 2014 15:55:10 GMT slchen 2014-07-14T15:55:10Z Character Year-Mon to Number Mon-Year https://communities.sas.com/t5/SAS-Procedures/Character-Year-Mon-to-Number-Mon-Year/m-p/178581#M45590 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>Could you please let me know how to convert character year-month to number MonYear.&nbsp; The sample data below.</P><P></P><P>Pt No.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; date_have(character)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Date_need(numberic)</P><P>1001&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2001-10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; OCT2001</P><P>1002&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2010-08&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AUG2010</P><P>1003&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2009-01&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; JAN2009</P><P></P><P>Thanks in advance</P></BODY></HTML> Mon, 14 Jul 2014 15:39:31 GMT https://communities.sas.com/t5/SAS-Procedures/Character-Year-Mon-to-Number-Mon-Year/m-p/178581#M45590 Almighty 2014-07-14T15:39:31Z Re: Character Year-Mon to Number Mon-Year https://communities.sas.com/t5/SAS-Procedures/Character-Year-Mon-to-Number-Mon-Year/m-p/178582#M45591 <HTML><HEAD></HEAD><BODY><P>data want;<BR />&nbsp; set have;<BR />&nbsp; date_need=input(date_have,anydtdte7.);<BR />&nbsp; format date_need monyy7.;<BR />&nbsp; run;</P></BODY></HTML> Mon, 14 Jul 2014 15:55:10 GMT https://communities.sas.com/t5/SAS-Procedures/Character-Year-Mon-to-Number-Mon-Year/m-p/178582#M45591 slchen 2014-07-14T15:55:10Z