SET= Data Set Option
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)
|
| Alias: |
TBLSET |
| Default: |
NO |
| Data source: |
Teradata |
Syntax
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 to allow duplicate rows when creating a
table. This option overrides the default Teradata MULTISET characteristic.
Example: Create a Table without Duplicate Rows
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 datasets library=x;
delete test1;run;
data x.test1(TBLSET=YES);
i=1;output;
run;