https://communities.sas.com/t5/SAS-Programming/Convert-character-month-to-numeric/m-p/665406#M198968 <P>One way:</P> <PRE>data month; input m $5.; monthnum = month(input(m||'2020',monyy7.)); datalines; SEP SEP NOV JAN FEB FEB MAY JAN JUN OCT MAR AUG JUL JUL ; run;</PRE> <P>which inputs a string with a year appended using a monyy informat and extracts the month from that.</P> <P>Others 1) a bunch of If/then/else statements</P> <P>2) a select/ when block (a bit better than if/then/else</P> <P>3) a custom informat and and an input statement.</P> Fri, 26 Jun 2020 16:29:37 GMT ballardw 2020-06-26T16:29:37Z https://communities.sas.com/t5/SAS-Programming/Convert-character-month-to-numeric/m-p/665404#M198966 <P>Hi all,&nbsp;</P><P>&nbsp;</P><P>I am trying to convert character month to numeric. Can you please help me with this....</P><P>&nbsp;</P><P>Thanks in advance!&nbsp;</P><P>&nbsp;</P><P>below is the data:</P><P>data month;<BR />input m $5.;<BR />datalines;<BR />SEP<BR />SEP<BR />NOV<BR />JAN<BR />FEB<BR />FEB<BR />MAY<BR />JAN<BR />JUN<BR />OCT<BR />MAR<BR />AUG<BR />JUL<BR />JUL<BR />;<BR />run;</P> Fri, 26 Jun 2020 16:22:44 GMT https://communities.sas.com/t5/SAS-Programming/Convert-character-month-to-numeric/m-p/665404#M198966 chinna0369 2020-06-26T16:22:44Z https://communities.sas.com/t5/SAS-Programming/Convert-character-month-to-numeric/m-p/665405#M198967 <P>Asked, and answered, here:</P> <P>&nbsp;</P> <P><A href="https://communities.sas.com/t5/SAS-Enterprise-Guide/converting-month-to-number-from-1-to-12/td-p/492077" target="_blank">https://communities.sas.com/t5/SAS-Enterprise-Guide/converting-month-to-number-from-1-to-12/td-p/492077</A></P> Fri, 26 Jun 2020 16:27:36 GMT https://communities.sas.com/t5/SAS-Programming/Convert-character-month-to-numeric/m-p/665405#M198967 Norman21 2020-06-26T16:27:36Z https://communities.sas.com/t5/SAS-Programming/Convert-character-month-to-numeric/m-p/665406#M198968 <P>One way:</P> <PRE>data month; input m $5.; monthnum = month(input(m||'2020',monyy7.)); datalines; SEP SEP NOV JAN FEB FEB MAY JAN JUN OCT MAR AUG JUL JUL ; run;</PRE> <P>which inputs a string with a year appended using a monyy informat and extracts the month from that.</P> <P>Others 1) a bunch of If/then/else statements</P> <P>2) a select/ when block (a bit better than if/then/else</P> <P>3) a custom informat and and an input statement.</P> Fri, 26 Jun 2020 16:29:37 GMT https://communities.sas.com/t5/SAS-Programming/Convert-character-month-to-numeric/m-p/665406#M198968 ballardw 2020-06-26T16:29:37Z