IMSTAT Procedure (Data and Server Management)

PROC IMSTAT (Data and Server Management) Statement

Manages in-memory tables in a SAS LASR Analytic Server instance.

Syntax

Summary of Optional Arguments

Optional Arguments

Syntax

PROC IMSTAT <options>;

Summary of Optional Arguments

SIGNER="authorization-web-service-uri"

Optional Arguments

BATCHMODE

By default, the IMSTAT procedure operates in interactive mode. If your program contains errors that prevent SAS from parsing or executing statements, the errors are reported in the SAS log, but they do not stop the procedure. If the errors are fatal errors such as running out of memory on the SAS client, the procedure stops.

In contrast, when the BATCHMODE option is specified in the PROC IMSTAT statement, the procedure behaves with respect to error handling as if it were not an interactive procedure. Whenever an error occurs, the procedure terminates and sets the SYSERR macro variable.

Alias

BATCH

DATA=libref.member-name

specifies the table to access from memory. The libref must be assigned from a SAS LASR Analytic Server engine LIBNAME statement.

FMTLIBXML=file-reference

specifies the file reference for a format stream. For more information, see FMTLIBXML in the LASR procedure.

IMMEDIATE

specifies that the procedure executes one statement at a time rather than accumulating statements in RUN blocks.

Alias

SINGLESTEP

NODATE

specifies to suppress the display of time and date-dependent information in results from the TABLEINFO statement.

NOPREPARSE

prevents the procedure from pre-parsing and pre-generating code for temporary expressions, scoring programs, and other user-written SAS statements.

When this option is specified, the user-written statements are sent to the server "as-is" and then the server attempts to generate code from it. If the server detects problems with the code, the error messages might not to be as detailed as the messages that are generated by SAS client. If you are debugging your user-written program, then you might want to pre-parse and pre-generate code in the procedure. However, if your SAS statements compile and run as you want them to, then you can specify this option to avoid the work of parsing and generating code on the SAS client.

When you specify this option in the PROC IMSTAT statement, the option applies to all statements that can generate code. You can also exclude specific statements from pre-parsing by using the NOPREPARSE option in statements that allow temporary columns or the SCORE statement.

Alias

NOPREP

NOPRINT

This option suppresses the generation of ODS tables and other printed output in the IMSTAT procedure. You can use this option to suppress printed output during execution of the actions, and then use the REPLAY statement to print the tables at a later point in the procedure execution.

NOTIMINGMSG

When an action completes successfully, the IMSTAT procedure generates a SAS log message that contains the execution time of the request. Specify this option to suppress the message.

Alias

NOTIME

PGMMSG

specifies to capture messages associated with user-provided SAS statements on the server in a temporary table. Messages are produced when parsing errors occur, when code generation fails, or by PUT statements in a SAS program.

You can use this option as a debugging feature for SAS code that you submit through temporary column expressions. The macro variable _PGMMSG_ is used in the IMSTAT procedure to capture the name of the table. The _TEMPLAST_ macro variable is also updated in case this temporary table is the most recently created temporary table.

Alias

PROGMST

SIGNER="authorization-web-service-uri"

specifies the URI for the SAS LASR Authorization web service. For more information, see SAS Visual Analytics: Administration Guide.

Example

SIGNER="https://server.example.com/SASLASRAuthorization"

TEMPTABLEINFO

specifies to add additional information for temporary tables to the ODS table that is created on the SAS client. The information includes the time at which the temporary table was created in the server, the number of rows, and the number of columns.

Alias

TEMPINFO

TEMPTABLESQUEEZE

requests that the temporary tables generated in the PROC IMSTAT session are automatically squeezed (compressed). You can use the INFO option in the COMPRESS statement to determine the compression ratio that was applied to the table.

Alias

TEMPSQUEEZE

UCA

specifies that you want to use Unicode Collation Algorithms (UCA) to determine the ordering of character variables in the GROUPBY= operations and other operations that depend on the order of formatted values.

Alias

UCACOLLATION