Data Set Options for Relational Databases |
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
|
- YES
-
specifies that no duplicate rows are allowed.
- NO
-
specifies that duplicate rows are allowed.
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.
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;
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.