SAS Variable to DBMS Column Names When Creating Tables

Current SAS Variable Name	Desired DBMS Column Name	Required LIBNAME Option
any SAS variable name, such as `Miles`	default DBMS column name (following DBMS naming conventions), such as MILES	`preserve_col_names=no`
case-sensitive SAS variable name, such as `Miles`	case-sensitive DBMS column name, such as Miles	`preserve_col_names=yes`
a SAS variable name with characters that are not valid in a normailzed SAS name, such as Miles-to-Go	case-sensitive DBMS column that matches the SAS name, such as Miles-to-Go	`proc sql dquote=ansi` and `preserve_col_names=yes` or, in a DATA or PROC step, use a SAS name literal and `preserve_col_names=yes` and `validvarname=any`