SAS
names can be entered in either uppercase or lowercase. When you reference
Sybase objects through the
SAS/ACCESS interface, objects are case
sensitive and require no quotation marks.
However, Sybase is generally
set 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 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 enter them,
with the case preserved.
In the SQL pass-through
facility, all Sybase object names are case sensitive. The names are
passed to Sybase exactly as they are entered.