Solved: Convert character month to numeric

chinna0369 · Posted 06-26-2020 12:22 PM

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;

ballardw · Posted 06-26-2020 12:29 PM

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.

Norman21 · Posted 06-26-2020 12:27 PM

Asked, and answered, here:

Norman.
SAS 9.4 (TS1M6) X64_10PRO WIN 10.0.17763 Workstation

ballardw · Posted 06-26-2020 12:29 PM

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.

Convert character month to numeric