LABEL= Table Option

Specifies a label for a table.

Category:	Table Control
Data source:	SAS data set, SASHDAT file, SPD Engine data set

Syntax

Arguments

Details

Example

Syntax

LABEL= 'label '

Arguments

'label'

specifies a text string of up to 256 characters.

Requirements	For SAS data sets and SPD Engine data sets, if the text contains single quotation marks, use double quotation marks around the label. Or, use two single quotation marks in the label text and enclose the string in single quotation marks. To remove a label from a data set, assign a label that is equal to a blank that is enclosed in quotation marks.
	Always use single quotation marks for SASHDAT files.

Details

The labels specified with the LABEL= table option are stored as part of the table’s metadata; however, the information is not used in the FedSQL environment. That is, once stored, the label cannot be displayed with FedSQL. The label can be viewed with the SAS CONTENTS procedure.

You can use the LABEL= table option on both input and output tables. When you use the LABEL= table option on input tables, it assigns a label for the file for the duration of the operation. When this is specified for an output table, the label becomes a permanent part of that file.

A label assigned to a table remains associated with that table when you update a table in place, such as when you use the APPEND procedure or the MODIFY statement. However, a label is lost if you use a table with a previously assigned label to create a new table with the CREATE TABLE statement. For example, a label previously assigned to table ONE is lost when you create the new output table ONE in this CREATE TABLE statement:

create table one as select * from one;

Example

These examples assign labels to SAS data sets:

create table tst {option label='1976 W2 Info, Hourly'} (col1 char(4), col2 double);
create table tst1 {option label="Hillside's Daily Account"} as select from tst3;
create table tst2 {option label='Peter''s List'}(col1 char(20), col2 char(20));

Last updated: February 23, 2017