IMSTAT Procedure

Syntax

PROC IMSTAT <options>;
BALANCE </options>;
COLUMNINFO </ options>;
COMPUTE column-name "SAS-statements" </ option>;
DELETEROWS </ options>;
DISTRIBUTIONINFO </ option>;
DROPTABLE <libref.member-name>;
FETCH <variable-list> </ options>;
FREE resource-specification;
IMPORTCUBE <options>;
LIFETIME time-specification </ MODE= ABSOLUTE | LASTUSE >;
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(row <,> column) = macro-variable-name;
TABLE <libref.member-name>;
TABLEINFO </ options>;
UPDATE variable1=value1 <variable2=value2 ...> </options>;

Table of Procedure Tasks and Examples

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