SAS/ACCESS Software for Relational Databases: Reference

Case Sensitivity in SYBASE

SAS names can be entered in either uppercase or lowercase. When you reference SYBASE objects through the SAS/ACCESS LIBNAME engine, objects are case-sensitive and require no quotes.

However, SYBASE database is generally set for case sensitivity, and special consideration should be given to the names of objects (such as tables and columns) when they are to be used in SAS software by the SAS/ACCESS procedures. The ACCESS procedure converts SYBASE object names to uppercase unless they are enclosed in quotation marks. Any SYBASE objects that were given lowercase names, or whose names contain national or special characters, must be enclosed in quotation marks. The only exceptions are the SUBSET statement in the ACCESS procedure and the SQL statement in the DBLOAD procedure. Arguments or values from these statements are passed to SYBASE exactly as you type them, with the case preserved.

In the SQL Procedure Pass-Through Facility, all SYBASE object names are case sensitive. The names are passed to SYBASE exactly as they are typed.

For more information about case-sensitivity and SYBASE names, see SYBASE Naming Conventions.

Chapter Contents
Previous
Next
Top of Page