SAS/ACCESS Software for Relational Databases: Reference

Case Sensitivity in the ACCESS Procedure

SAS names can be entered in either uppercase or lowercase. However, some host-operating environments and some DBMSs are case sensitive and therefore, special consideration should be used when the names of DBMS objects (such as tables and columns) are used in the SAS System. See the "Naming Conventions" section in your DBMS chapter for more information on case sensitivity.

The ACCESS procedure generally converts DBMS object names to uppercase unless they are enclosed in quotes. Any DBMS objects that were given lowercase names when they were created, or whose names contain special or national characters, must be enclosed in quotes.

Chapter Contents
Previous
Next
Top of Page