| Current DBMS Column Name | Desired SAS Variable Name | Required LIBNAME Option |
| DBMS column name with characters invalid for SAS names, such as My$Data | case-sensitive SAS variable name with underscore replacing invalid characters,
such as My_Data |
None |
| case-sensitive DBMS column name, such as Flight | case-sensitive SAS variable name, such as Flight |
None |
| DBMS column name with characters invalid for SAS names, such as My$Data | nonstandard, case-sensitive SAS variable name, such as My$Data |
proc sql dquote=ansi or, in a
DATA or PROC step, use a SAS name literal such as 'My$Flight'n
and validvarname=any |
Copyright © 2002 SAS Institute Inc.,
Cary, NC, USA. All rights reserved.