When the engine reads DBMS column names that contain
characters that are not standard in SAS names, the default behavior
is to replace an unsupported character with an underscore (_). For
example, the DBMS column name Amount Budgeted$ becomes the SAS name
Amount_Budgeted_.
Note: Nonstandard names include
those with blank spaces or special characters (such as @, #, %) that
are not allowed in SAS names.
When the engine encounters
a DBMS name that exceeds 32 characters, it truncates the name. After
it has modified or truncated a DBMS column name, SAS appends a number
to the variable name, if necessary, to preserve uniqueness. For example,
DBMS column names MY$DEPT, My$Dept, and my$dept become SAS names MY_DEPT,
MY_Dept0, and my_dept1.