SAS/ACCESS Software for Relational Databases: Reference

Naming Limits in the DBLOAD Procedure

In Version 8, the DBLOAD procedure still limits SAS variable names to a maximum of eight characters in length. If you need to load 32-character column names into the DBMS, it is recommended that you use the SAS/ACCESS LIBNAME statement or the SQL Procedure Pass-Through Facility instead of PROC DBLOAD.

You can use long member names in the PROC DBLOAD DATA= option, such as the name of a SAS data set that you want to load into a DBMS table. However, if you attempt to use long SAS variable names, you will get an error message advising you that long variable names are not supported in PROC DBLOAD. As in previous versions, you can use the PROC DBLOAD RENAME statement to rename the eight-character SAS variable names to long DBMS column names when you load the data into a DBMS table. You can also use the RENAME data set option to rename the columns after they are loaded into the DBMS.

Chapter Contents
Previous
Next
Top of Page