SAS Institute. The Power to Know

SAS/ACCESS(R) 9.2 Interface to PC Files: Reference

space
Previous Page | Next Page

The LIBNAME Statement for PC Files on Microsoft Windows

DBCREATE_TABLE_OPTS= Data Set Option



Specifies data source-specific syntax to be added to the CREATE TABLE statement.
Valid in: DATA and PROC steps (when accessing PC files data using SAS/ACCESS software)
Default value: LIBNAME option setting

Syntax
Syntax Description
Details
See Also

Syntax

DBCREATE_TABLE_OPTS='SQL-clauses'

Syntax Description

SQL-clauses

are one or more data source-specific clauses that can be appended to the end of an SQL CREATE TABLE statement.


Details

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.


See Also

To assign this option to a group of tables, use the DBCREATE_TABLE_OPTS= option specified in LIBNAME Options for PC Files on Microsoft Windows.

space
Previous Page | Next Page | Top of Page