If the aforementioned options are not set, the following rules apply when you map DBMS column names to SAS variable names: Characters that are not standard in SAS names (such as @ and #) that appear ...
A case-sensitive SAS variable name, such as Miles Case-sensitive DBMS column name, such as Miles preserve_col_names=yes Any SAS data set name, such as Payroll Default DBMS table name (normalized to ...