topic Re: Inverse of the 'month' function in SAS Enterprise Guide

Inverse of the 'month' function

Lupacante — Fri, 09 May 2014 15:33:07 GMT

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 — Fri, 09 May 2014 15:38:43 GMT

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

ChrisHemedinger — Fri, 09 May 2014 15:41:01 GMT

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 — Fri, 09 May 2014 15:41:40 GMT

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.);

ChrisHemedinger — Fri, 09 May 2014 15:41:46 GMT

ooh, just beat me to it.

Lupacante — Fri, 09 May 2014 15:59:04 GMT

Thanks!

but why 1960?

DBailey — Fri, 09 May 2014 16:10:05 GMT

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