IMSTAT Procedure (Data and Server Management)
- Syntax
Procedure SyntaxPROC IMSTAT (Data and Server Management) StatementBALANCE StatementCOLUMNINFO StatementCOMPRESS StatementCOMPUTE StatementCREATETABLE StatementDELETEROWS StatementDISTRIBUTIONINFO StatementDROPCOLUMN StatementDROPTABLE StatementFETCH StatementFREE StatementLIFETIME StatementNUMROWS StatementPARTITION StatementPARTITIONINFO StatementPROMOTE StatementPURGETEMPTABLES StatementREPLAY StatementSAVE StatementSCHEMA StatementSCORE StatementSERVERINFO StatementSERVERPARM StatementSERVERTERM StatementSERVERWAIT StatementSET StatementSTORE StatementTABLE StatementTABLEINFO StatementUNCOMPRESS StatementUPDATE StatementQUIT Statement - Overview
- Concepts
- Examples
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 |
Syntax
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.
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).
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= |