topic Re: how to format date in SAS Programming

how to format date

Ravikumarkummari — Wed, 04 Mar 2015 13:12:51 GMT

Hi all,

if the dates are in the format mmddyy10. but i want the output like mon-year format.

ex:

jan-2000

feb-2000

mar-1989 in this format.

how this is done in sas.

Thanks in advance all

Re: how to format date

data_null__ — Wed, 04 Mar 2015 13:27:38 GMT

MONYY7 format is pretty close but if you want lowercase and the dash you will probably need to use a picture format. Not sure about the lowercase you can RTM since you're the one that wants it.

Re: how to format date

Kurt_Bremser — Wed, 04 Mar 2015 13:27:56 GMT

Assuming you already have your date in SAS date format (number containing days from 01jan1960):

length datestr $8;

datestr = lowcase(put(yourdate,monyy7.));

datestr = substr(datestr,1,3) !! '-' !! substr(datestr,4);

put datestr=;