IMSTAT Procedure (Data and Server Management)

PARTITION Statement

The PARTITION statement is used to generate a temporary table from the active table and partition it according to the statement options. This re-partitioning of tables is supported for distributed and non-distributed SAS LASR Analytic Server.

Examples:

Partitioning a Table into a Temporary Table

Appending a Non-Partitioned Table to a Partitioned Table

Syntax

PARTITION Statement Options

Details

ODS Table Names

Syntax

PARTITION variable-list </ options>;

PARTITION Statement Options

DESCENDING=(variable-list)

DESCENDING=variable-name

specifies the variables in the ORDERBY= list to use with a descending sort order. Specifying the DESCENDING= option by itself has no effect on ordering within a partition. The option is specified in addition to the ORDERBY= option.

Alias	DESC=
Example	The following statement requests partitioning of the active table by variables A and B, and ordering within the partition by ascending value of column C and descending value of column D: partition a b / orderby=(c d) descending=d;

FORMATS=("format-specification"<,...>)

specifies the formats for the PARTITIONBY= variables. If you do not specify the FORMATS= option, the default format is applied for that variable. The format of a partitioning variable is important because the equality of the partition keys is determined from the formatted values.

Enclose each format specification in quotation marks and separate each format specification with a comma.

NOMISSING

specifies that missing values are excluded in the determination of partition keys. By default, observations with missing values are included.

Alias

NOMISS

ORDERBY=(variable-list)

ORDERBY=variable-name

specifies the variable or variables to use for ordering the observations within a partition. By default, the sort order for the ORDERBY= variables is ascending in raw values and follows location and collation rules. If you want to order some ORDERBY= variables in descending sort order, then specify the variable names in the DESCENDING= option (in addition to listing them in the ORDERBY= option).

The ORDERBY= variables are transferred automatically to the partitioned temporary table, whether you list them in the VARS= option or not.

SAVE=table-name

saves the result table so that you can use it in other IMSTAT procedure statements like STORE, REPLAY, and FREE. The value for table-name must be unique within the scope of the procedure execution. The name of a table that has been freed with the FREE statement can be used again in subsequent SAVE= options.

TEMPEXPRESS="SAS-expressions"

TEMPEXPRESS=file-reference

specifies either a quoted string that contains the SAS expression that defines the temporary variables or a file reference to an external file with the SAS statements.

Alias

TE=

TEMPNAMES=variable-name

TEMPNAMES=(variable-list)

specifies the list of temporary variables for the request. Each temporary variable must be defined through SAS statements that you supply with the TEMPEXPRESS= option.

Alias

TN=

VARIABLES=(variable-list)

VARIABLES=variable-name

specifies the variable or variables to include in the temporary table in addition to the partitioning variables. If you do not specify the VARS= option, then all the variables are transferred from the active table. Temporary calculated columns are also transferred to the temporary table.

Alias

VARS=

Details

ODS Table Names

The PARTITION statement generates the following ODS table.

ODS Table Name	Description	Option
TempTable	Information about a temporary table	Default

For information about using the ODS table with SAVE= option, see the Details section of the STORE statement. However, the information that is available in the ODS table, the temporary table name, is automatically placed in the &_TEMPLAST_ macro variable.