BookmarkSubscribeRSS Feed
Ravikumarkummari
Quartz | Level 8

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

2 REPLIES 2
data_null__
Jade | Level 19

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.

Kurt_Bremser
Super User

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

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1380 views
  • 0 likes
  • 3 in conversation