DATA Step, Macro, Functions and more

how to format date

Reply
Frequent Contributor
Posts: 111

how to format date

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

Respected Advisor
Posts: 3,777

Re: how to format date

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.

Super User
Posts: 6,946

Re: how to format date

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=;

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Ask a Question
Discussion stats
  • 2 replies
  • 197 views
  • 0 likes
  • 3 in conversation