Date Format
Date Format
(OP)
I have column which looks like:
1112
1113
1114
1115
...
...
I need it to look like this:
11/12
11/13
11/14
...
...
Thanks
1112
1113
1114
1115
...
...
I need it to look like this:
11/12
11/13
11/14
...
...
Thanks
RE: Date Format
See in PDF "SAS Language Reference: Dictionary" in "Chapter 3: Formats" the section on MMDDYYw. format for details.
CODE
length txtDate $5
numDate 8
;
/*-- as text - not so nice */
txtDate = '0225';
txtDate = substr(txtDate,1,2) !! '/' !! substr(txtDate,3);
put ' Brute Force Text: ' txtDate;
/*-- as numeric date */
numDate = '25-FEB-2011'd;
put ' Full numeric Date: ' numDate YYMMDD10.;
put 'Short numeric Date: ' numDate MMDDYY5.;
/*-- to store from number as text: */
txtDate = put (numDate, MMDDYY5.);
run;
OUTPUT:
Brute Force Text: 02/25
Full numeric Date: 2011-02-25
Short numeric Date: 02/25