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