MMDDYY+: Format that inserts a slash, space or "-" between the date, month and year
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...