IMSTAT :: SAS(R) LASR(TM) Analytic Server 2.2: Reference Guide

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 >;

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(row <,> column) = macro-variable-name;

TABLE <libref.member-name>;

TABLEINFO </ 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