LABEL

LABEL

Causes DBMS column names to default to SAS labels.

Optional statement

Interacts with: RESET

Default: DBMS column names default to SAS variable names

Syntax
Details

Syntax

LABEL;

Details

The LABEL statement causes the DBMS 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 DBMS column name, the label is truncated.

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 connection statements when you create and load a DBMS table. See LOAD for more information.

Chapter Contents
Previous
Next
Top of Page

	Optional statement
Interacts with:	RESET
Default:	DBMS column names default to SAS variable names