Previous Page | Next Page

Data Set Options for Relational Databases

PARTITION_KEY= Data Set Option



Specifies the column name to use as the partition key for creating fact tables.
Default value: none
Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
DBMS support: Aster nCluster

Syntax
Details
See Also

Syntax

PARTITION_KEY='column-name'

Details

You must enclose the column name in quotation marks.

Aster nCluster uses dimension and fact tables. To create a data set in Aster nCluster without error, you must set both the DIMENSION= and PARTITION_KEY= (LIBNAME or data set) options.


See Also

To assign this option to a group of relational DBMS tables or views, see the PARTITION_KEY= LIBNAME Option.

DIMENSION= Data Set Option

Previous Page | Next Page | Top of Page