Providing software solutions since 1976

• Log in
• Create profile
• Welcome
  [Log out]
• Edit profile

• Print  |
• Feedback  |
• Share

  • E-mail

  
  
  

  E-mail This Page

  Your Name:*
  Your E-mail:*
  Recipient E-mail:*
  Send a copy to me
  Personal Message:
  
  

  * indicates a required field

Beginning in Version 7, you can use PROC FORMAT and the PICTURE
statement to display many permutations for DATE, TIME, and DATETIME
values.  The DATATYPE= option on the PICTURE statement specifies that
you can use directives in the picture as a template to format DATE, TIME, or DATETIME values.  A list of directives is available on page
445 of the SAS Procedures Guide, Version 8.

For example:

  1. The maximum width for the DATEw. format is 9.  If you want
     a 4-digit year and have delimiters, use:

     proc format;
       picture date11_ (default=11) other='%0d-%0b-%Y' (datatype=date);
     run;

     Formatted dates appear as "dd-mmm-yyyy".  To produce a
     2-digit year, use %0y rather than %Y.

  2. DATETIMEw.d formats values as "ddmmmyyyy:hh:mm:ss.ss".
     If you want values displayed as "mm/dd/yyyy hh:mm:ss",
     use:

     proc format;
       picture dttime other='%0m/%0d/%0y %0H:%0M:%0S'
       (datatype=datetime);
     run;

Operating System and Release Information