IMSTAT Procedure (Data and Server Management)

Syntax

PROC IMSTAT <options>;

BALANCE </options>;

COLUMNINFO </ options>;

COMPRESS </ options>;

COMPUTE column-name "SAS-statements" </ option>;

CREATETABLE table-name column-specification1 <column-specification2...> </ options>;

DELETEROWS </ options>;

DISTRIBUTIONINFO </ option>;

DROPCOLUMN column-name;

DROPTABLE <libref.member-name>;

FETCH <variable-list> </ options>;

FREE resource-specification;

LIFETIME time-specification <MODE= ABSOLUTE | LASTUSE >;

NUMROWS;

PARTITION variable-list </ options>;

PARTITIONINFO </ options>;

PROMOTE member-name </ options>;

PURGETEMPTABLES <options>;

REPLAY table-list;

SAVE <options>;

SCHEMA dim-specification1 <dim-specification2 ...> </ options>;

SCORE CODE=file-reference <options>;

SERVERINFO <option>;

SERVERPARM <options>;

SERVERTERM <options>;

SERVERWAIT <options>;

SET set-specification1 <set-specification2 ...> </ options>;

STORE <table-name <[table-number]>>

(row-number | _ALL_ | _LAST_ | row-list | WHERE=(where-clause) <,>

column-number | _ALL_ | COLS=column-list) = macro-variable-name </ options>;

TABLE <libref.member-name>;

TABLEINFO </ options>;

UNCOMPRESS </ options>;

UPDATE variable1=value1 <variable2=value2 ...> </options>;

QUIT;

Statement	Task	Example
BALANCE	Rebalancing a table	Ex. 3
DELETEROWS	Deleting rows and saving a table to HDFS	Ex. 4
PARTITION	Partitioning a table into a temporary table	Ex. 1
PROMOTE	Promoting temporary tables to regular tables	Ex. 2
SCHEMA	Creating a star schema	Ex. 5
SET	Appending tables	Ex. 6