Inverse of the 'month' function

[Lupacante]

Hi all,

is there a way to assosciate numbers from 1 to 12 with the 12 months without having to down the long-winded road of

if x = 1 then my_month = 'JAN';

else if x=2 then my_month = 'FEB';

...

else if x=12 then my_month = 'DEC'

?

Thanks,

Marco

[DBailey · Accepted solution]

put(mdy(x,1,1960),monname3.)

[ChrisHemedinger]

ooh, just beat me to it.

[Lupacante]

Thanks!

but why 1960?

[DBailey]

the year is actually irrelevant but that's the year for sas date = 0.

[ChrisHemedinger]

How about:

my_month = put(mdy(x,1,2013),monname3.);

MDY takes a month number, day number, and year.  In your case, the day and year can be anything.

Chris

[jwillis]

Absolutely.

One way of many is to code a proc format that contains the values.

For example (untested):

proc format;

    value myname

        1 = "JAN"

         2 = "FEB"

etc....

      other = "err"            /* in case you have a number greater than 12, missing or zero */

;

run;

............................

my_month  = put(x,myname.);