Data Set Options for Relational Databases

SET= Data Set Option

Specifies whether duplicate rows are allowed when creating a table.

Alias:	TBLSET
Default value:	NO
Valid in:	DATA and PROC steps (when creating and appending to DBMS tables using SAS/ACCESS software)
DBMS support:	Teradata

Syntax
Syntax Description
Details
Example

Syntax

SET=YES | NO

Syntax Description

YES: specifies that no duplicate rows are allowed.
NO: specifies that duplicate rows are allowed.

Details

Use the SET= data set option to specify whether duplicate rows are allowed when creating a table. The default value for SET= is NO. This option overrides the default Teradata MULTISET characteristic.

Example

This example creates a Teradata table of type SET that does not allow duplicate rows.

libname trlib teradata user=testuser pw=testpass;
options sastrace=',,,d' sastraceloc=saslog;
proc delete data=x.test1;
run;

data x.test1(TBLSET=YES);
i=1;output;
run;

Top of Page