IMSTAT Procedure
- Syntax
Procedure SyntaxPROC IMSTAT StatementBALANCE StatementCOLUMNINFO StatementCOMPUTE StatementDELETEROWS StatementDISTRIBUTIONINFO StatementDROPTABLE StatementFETCH StatementFREE StatementIMPORTCUBE StatementLIFETIME StatementNUMROWS StatementPARTITION StatementPARTITIONINFO StatementPROMOTE StatementPURGETEMPTABLES StatementREPLAY StatementSAVE StatementSCHEMA StatementSCORE StatementSERVERINFO StatementSERVERPARM StatementSERVERTERM StatementSERVERWAIT StatementSET StatementSTORE StatementTABLE StatementTABLEINFO StatementUPDATE StatementQUIT Statement - Overview
- Concepts
- Examples
FETCH Statement
The FETCH statement is used to retrieve rows from an in-memory table. You can use the FETCH statement to retrieve calculated columns that are calculated according to a script as part of the request. The columns that are calculated this way do not persist beyond the time it takes to execute in the server.
Syntax
FETCH Statement Options
ARRAYSTART=n
specifies the starting element of an array when the record of an in-memory table represents a variable array. This is the case, for example, when a pricing cube from SAS High-Performance Risk is loaded into a server. There might then be 10,000 columns for a variable. Specifying the ARRAYSTART= and ARRAYLENGTH= options enables you to page through the data more conveniently.
ARRAYLENGTH=k
specifies the length of the array to fetched when the record of an in-memory table represents a variable array. Use this option with the ARRAYSTART= option.
FORMAT
specifies that you want to retrieve formatted values. By default, the FETCH statement retrieves the raw values. Be aware that when you retrieve raw values and you create an output data set, the variable information such as formats and labels are transferred to the output data set.
FROM=first-index
specifies the index of the first row to retrieve (inclusive). The value for first-index is 1-based.
| Default | FROM=1 |
| Interaction | The value for FROM= is applied after the evaluation of a WHERE clause. |
OUT=libref.member-name
specifies the name of the data set to store the result set of the FETCH statement.
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.
SETSIZE
requests that the server estimate the size of the result set. The procedure does not create a result table if the SETSIZE option is specified. Instead, the procedure reports the number of rows that are returned by the request and the expected memory consumption for the result set (in KB). If you specify the SETSIZE option, the SAS log includes the number of observations and the estimated result set size. See the following log sample:
NOTE: The LASR Analytic Server action request for the STATEMENT
statement would return 17 rows and approximately
3.641 kBytes of data.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= |
TO=last-index
specifies the index of the last row to retrieve (inclusive). The value for last-index is 1-based.
| Default | The default value is FROM=first-index + 19. |
| Interaction | The value for TO= is applied after the evaluation of a WHERE clause. |