IMSTAT Procedure (Data and Server Management)

TABLE Statement

The TABLE statement is used to specify the in-memory table to use for subsequent IMSTAT procedure statements. You can use this statement to switch between different in-memory tables in a single run of the IMSTAT procedure.

Example:

Creating a Star Schema

Syntax

Optional Argument

Example

Syntax

TABLE <libref.member-name>;

Optional Argument

libref.member-name

specifies the libref for the SAS LASR Analytic Server and the table name.

If you do not specify the libref and member-name, the procedure closes the table that is currently open.

Example

A common use for the TABLE statement is to reference a temporary table with the libref.&_TEMPLAST_ macro variable. Temporary tables are in-memory tables that are created with the results of a statement that supports the TEMPTABLE option.

Tip

Make sure that the statement that generated the temporary table is separated from the next statement with a RUN statement. The temporary table does not exist at parse time, it is created at run time when the statement is executed.

proc imstat data=lasrlib.sales2012;
    partition customerid;
run;

    table lasrlib.&_templast_;
run;

    /*
     *  More statements for the partitioned table. 
     *  The PROMOTE statement can be used to convert the
     *  temporary table to a regular table.
     */
quit;