LIBNAME Statement: PC Files on Linux, UNIX, and 64-Bit Microsoft Windows |
Specifies data source-specific syntax to add to the CREATE TABLE
statement.
Valid in: |
DATA and PROC steps
|
Default value: |
LIBNAME option setting
|
DBCREATE_TABLE_OPTS='SQL-clauses'
|
- SQL-clauses
-
are one or more data source-specific clauses that can be
appended to the end of an SQL CREATE TABLE statement.
This option enables you to add data source-specific clauses
to the end of the SQL CREATE TABLE statement. The SAS/ACCESS engine
passes the SQL CREATE TABLE statement and its clauses to the data source,
which executes the statement and creates the table.
To assign this option to a group of tables, use the DBCREATE_TABLE_OPTS=
option specified in LIBNAME Options.
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.