PARTITION_KEY= LIBNAME Option

Specifies the column name to use as the partition key for creating fact tables.

Valid in:	SAS/ACCESS LIBNAME statement
Default:	none
Requirements:	To create a data set in Aster nCluster without error, you must either set DIMENSION= YES (LIBNAME or data set option) or specify a partition key in the PARTITION_KEY= (LIBNAME or data set) option. You must enclose the column name in quotation marks.
Data source:	Aster nCluster
See:	DIMENSION= LIBNAME option, , DIMENSION= data set option, PARTITION_KEY= data set option

Syntax

Details

Example

Syntax

PARTITION_KEY='column-name'

Details

Aster nCluster uses dimension and fact tables.

Example: Create a Dimension Table

This first example shows how you can use the SAS data set, SASFLT. flightschedule, to create an Aster nCluster dimension table, flightschedule by using the DIMENSION= DATA step option.

LIBNAME sasflt 'SAS-library';
LIBNAME net_air ASTER user=louis pwd=fromage server=air2 database=flights;
data net_air.flightschedule(dimension=yes);
  set sasflt. flightschedule;
run;

You can create the same Aster nCluster dimension table by setting DIMENSION=YES in the LIBNAME statement.

LIBNAME sasflt 'SAS-library';
LIBNAME net_air ASTER user=louis pwd=fromage server=air2
        database=flights dimension=yes;
data net_air.flightschedule;
  set sasflt. flightschedule;
run;

If you do not set DIMENSION=YES by using either the LIBNAME or data set option, the Aster nCluster engine tries to create an Aster nCluster fact table. To do this, however, you must set the PARTITION_KEY= LIBNAME or data set option, as shown in this example.

LIBNAME sasflt 'SAS-library';
LIBNAME net_air ASTER user=louis pwd=fromage server=air2 database=flights;
data net_air.flightschedule(dbtype=(flightnumber=integer)
     partition_key='flightnumber');
  set sasflt. flightschedule;
run;

You can create the same Aster nCluster fact table by using the PARTITION_KEY= LIBNAME option.

LIBNAME sasflt 'SAS-library';
LIBNAME net_air ASTER user=louis pwd=fromage server=air2 database=flights
        partition_key='flightnumber';
data net_air.flightschedule(dbtype=(flightnumber=integer));
  set sasflt. flightschedule;
run;

The above examples use the DBTYPE= data set option so that the data type of the partition-key column meets the limitations of the Aster nCluster partition-key column.