topic Re: Conversion of month in character to numeric in SAS Programming

Conversion of month in character to numeric

abhi18sas — Thu, 29 Mar 2018 18:58:49 GMT

Hi,

So, I have a variable named Birthmonth which has Months in Character i.e January, February...etc

I want these to be converted into their respective numeric equals.

How to do this?

Re: Conversion of month in character to numeric

art297 — Thu, 29 Mar 2018 19:14:00 GMT

Here is one way:

data want;
  set have;
  month=month(input(catt('1',substr(birthmonth,1,3),'2018'),date9.));
run;

Art, CEO, AnalystFinder.com

Re: Conversion of month in character to numeric

ballardw — Thu, 29 Mar 2018 19:16:17 GMT

Here are two ways:

data want;
   set have;
   select (birthmonth);
      when ('January')   monthnum=1;
      when ('February')  monthnum=2;
      when ('March')     monthnum=3;
      when ('April')     monthnum=4;
      when ('May')       monthnum=5;
      when ('June')      monthnum=6;
      when ('July')      monthnum=7;
      when ('August')    monthnum=8;
      when ('September') monthnum=9;
      when ('October')   monthnum=10;
      when ('November')  monthnum=11;
      when ('December')  monthnum=12;
      otherwise;
   end;
run;

data want;
   set have;
   birthmonth='January';
   array m(12) $ 15 _temporary_('January','February','March','April','May','June','July','August','September'
       'October','November','December') ;
  monthnum = whichc(birthmonth,of m(*));
run;

Both of these are case sensitive. So if your spelling changes case such as "MAY", "May" and "may" you would want to use a case function on your variable (propcase(birthmonth) most likely) and use the appropriate comparison.

Re: Conversion of month in character to numeric

abhi18sas — Fri, 30 Mar 2018 04:35:53 GMT

Thanks!!