Specifies whether duplicate rows are allowed when creating a table.
| Valid in: | DATA and PROC steps (when creating and appending to DBMS tables using SAS/ACCESS software) |
|---|---|
| Category: | Data Set Control |
| Alias: | TBLSET |
| Default: | NO |
| Data source: | Teradata |
Table of Contents
specifies that no duplicate rows are allowed.
specifies that duplicate rows are allowed.
Use the SET= data set option to specify whether to allow duplicate rows when creating a table. This option overrides the default Teradata MULTISET characteristic.
This example creates a Teradata table of type SET that does not allow duplicate rows.
libname trlib teradata user=myusr1 pw=mypwd1;
options sastrace=',,,d' sastraceloc=saslog;
proc datasets library=x;
delete test1;run;
data x.test1(TBLSET=YES);
i=1;output;
run;