The DBLOAD Procedure

LABEL Statement

Causes DBMS column names to default to SAS labels.
Default: SAS labels.
Restrictions: For the LABEL statement to take effect, the RESET statement must be used after the LABEL statement.

An editing statement, such as LABEL, must be specified after the database-description statements when you create and load PC files.

Interaction: RENAME, RESET
Syntax
Details

Syntax

LABEL;

Details

The LABEL statement causes the column names to default to the SAS variable labels when the new table is created. If a SAS variable has no label, the variable name is used. If the label is too long to be a valid column name, the label is truncated.
Copyright © SAS Institute Inc. All rights reserved.