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 ...

Column names can be case-sensitive also. Some DBMSs allow case sensitive column and table names as ... renamed to different SAS variable names: "Amount Budgeted$" becomes "Amount_Budgeted_" and ...