Previous Page | Next Page

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;

Previous Page | Next Page | Top of Page