Convert character month to numeric

[chinna0369]

Hi all, 

I am trying to convert character month to numeric. Can you please help me with this....

Thanks in advance! 

below is the data:

data month;
input m $5.;
datalines;
SEP
SEP
NOV
JAN
FEB
FEB
MAY
JAN
JUN
OCT
MAR
AUG
JUL
JUL
;
run;

[Norman21]

Asked, and answered, here:

https://communities.sas.com/t5/SAS-Enterprise-Guide/converting-month-to-number-from-1-to-12/td-p/492...

[ballardw · Accepted solution]

One way:

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;

which inputs a string with a year appended using a monyy informat and extracts the month from that.

Others 1) a bunch of If/then/else statements

2) a select/ when block (a bit better than if/then/else

3) a custom informat and and an input statement.