IMSTAT Procedure (Data and Server Management)

UNCOMPRESS Statement

The UNCOMPRESS statement is used to create a regular in-memory table from a compressed in-memory table. The result is stored as a temporary table.

Syntax

UNCOMPRESS Statement Options

Details

ODS Table Names

Example

Syntax

UNCOMPRESS </ options>;

UNCOMPRESS Statement Options

INFO

requests the server to report information about the compression state of a table, but does not perform uncompression. On a compressed table, the report includes information about the compressed size and compression ratio. On an uncompressed table, the results include the uncompressed size only. The option is also useful to find out how much memory a table consumes.

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.

Details

ODS Table Names

The UNCOMPRESS statement generates the following ODS tables.

ODS Table Name	Description	Option
Compress	Information from compressing or uncompressing tables	Default
TempTable	Information about a temporary table	When the INFO option is not used, a temporary table is generated.

For information about using the ODS table with SAVE= option, see the Details section of the STORE statement.

Example

data lasr.prdsalecomp(squeeze=yes);  1
    set sashelp.prdsale;
run;

proc imstat data=lasr.prdsalecomp;
    uncompress / info;  2
run;
    uncompress;
    table lasr.&_templast_;
    promote prdsalenocomp;  3
run;
    table lasr.prdsalenocomp;
    uncompress / info;  4
quit;

1	The SQUEEZE=YES data set option is used so that the server compresses the table as it is loaded to memory.
2	The INFO option is used to report the compression information for the table.
3	The PROMOTE statement is used to make the uncompressed table into a permanent table and give it a name.
4	The INFO option is used to report the compression information for the table.