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

When you use SAS/ACCESS Interface to Oracle, SAS uses the "DDMONYYY:HH:MI:SS" Oracle format by default. When either the SAS date, datetime,or time variable type does not match the value that is stored in the Oracle column, you can use either 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 later, you can globally set the SASDATEFMT option in the configurations file or as an environment variable.

To use the option in the configuration file, edit the sasv8.cfg file and add the option as follows:

Be sure to close SAS and then re-start it in order for this setting to take effect.

To use this option as an environment variable:

• In Windows operating environments:
  1. Select Start ► Settings ► Control Panel ► System to display the System Properties dialog box.
  2. In the dialog box, click the Environment tab and enter the following information:
     • Enter SASDATEFMT for Variable Type.
     • Enter DATE for Value Type.
     • Click Set.
     • Click Apply.
• In UNIX operating environments, add the following:
  • For ksh: export SASDATEFMT=DATE
  • Fore csh: setenv SASDATEFMT DATEM

  Under 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, close it down and re-start it in order for the setting to take effect. Refer to SAS Note 38864 for a possible performance problem.

Operating System and Release Information