SAS names can be entered in either uppercase or lowercase. When you reference SAP ASE objects through the SAS/ACCESS interface, objects are case sensitive and require no quotation marks.
However, SAP ASE is generally specified for case sensitivity. Give special consideration to the names of such objects as tables and columns when the SAS ACCESS or DBLOAD procedures are to use them. The ACCESS procedure converts SAP ASE object names to uppercase unless they are enclosed in quotation marks. Any SAP ASE 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 SAP ASE exactly as you enter them, with the case preserved.
In the SQL pass-through facility, all SAP ASE object names are case sensitive. The names are passed to SAP ASE exactly as they are entered.
For more information about case sensitivity and SAP ASE names, see Naming Conventions for SAP ASE.