INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS Contact USThanks. We have received your request and will respond promptly. Come Join Us!Are you a
Computer / IT professional? Join Tek-Tips Forums!
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting Guidelines |
|
Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.
Here's Why Members Love Tek-Tips Forums:
Talk To Other MembersRegister now while it's still free!
Already a member? Close this window and log in.
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