MMDDYY+: Format that inserts a slash, space or "-" between the date, month and year

This post was kindly contributed by StudySAS Blog - go there to comment and to read the full post.

Here is another new format which is available with SAS 9 version called MMDDYY+ . (MMDDYY+ format can insert colons /slash or periods etc between date, month and year values); This new date format developed by SAS works for many other formats, for ex:

MMDDYYB.; *format inserts Blanks in between date, month and years;

MMDDYYC.; *format inserts Colons in between date, month and years;

MMDDYYD.; *format inserts Dashes in between date, month and years;

MMDDYYN.;*format inserts Nothing in between date,month & years;

MMDDYYP.; *format inserts Periods in between date, month & years;

MMDDYYS.; *format inserts Slash in between date, month and years;

When you have date, month and year as separate variables and you want to insert colons or slash or periods and even blanks between them…. MMDDYY+ is your answer.

Here I will show how?

data have;

input date month year;

cards;

25 1 2005

19 3 2006

12 2 2004

1 12 2007

;

run;

data want;

set have;…