• Print |
• E-mail  |
• Bookmark

The SASDATEFMT option can be used in the config file or as an
environment variable with SAS 8.2.  When using SAS/ACCESS Interface to
Oracle,  SAS uses the "DDMONYYY:HH:MI:SS" Oracle format by default.
When the SAS date, datetime or time variable type does not match the
value stored in the Oracle column, you can use the SASDATEFMT option to
specify an alternate format or the DATEPART or TIMEPART function to
extract the date or time portion.

With SAS 8.2 and higher, you can globally set the SASDATEFMT option in
the config file or as an environment variable.

To use in the config file, edit the sasv8.cfg file and add an option:

  -set SASDATEFMT date

Make sure to close down SAS and re-start for the settings to be
effective.

To use this option as an environment variable:

  On Windows:

    Go to:
    Start -> Settings -? Control Panel
    Double click on System
    Click on Environment tab
    Type SASDATEFMT for Variable Type
    Type DATE for Value Type
    Click Set
    Click Apply

  On UNIX:

    ksh: export SASDATEFMT=DATE

    csh: setenv SASDATEFMT DATE

On Unix, you can also specify the option on the SAS invocation line as
follows:

  unix_prompt> sas -set SASDATEFMT date

If you are currently running SAS you will need to close it down and
re-start for the setting to be effective.

Operating System and Release Information