SAS/ACCESS automatically
converts Teradata column names that are not valid for SAS, mapping
such characters to underscores. It also appends numeric suffixes to
identical names to ensure that column names are unique.
create table unusual_names( Name$ char(20), Name# char(20),
"Other strange name" char(20))
In this example
SAS/ACCESS
converts the spaces found in the Teradata column name, OTHER STRANGE
NAME, to Other_strange_name. After the automatic conversion, SAS programs
can then reference the table as usual.
libname unusual teradata user=testuser password=testpass;
proc print data=unusual.unusual_names; run;
PROC PRINT Display
Name_ Name_0 Other_strange_name