SPDO Procedure

Requirements: You must have special privilege to issue proxy management and server management statements.
You must be the resource owner, have ACL access, or have special privilege in order to issue ACL definition and management statements and table management statements.

Syntax

PROC SPDO LIB=libref;
In alphabetical order, optional statements are:
ADD ACL acl1[, acl2...][C=cat T=type][/options];
CLUSTER ADD cluster-tablename MEMBER=member-name1[, MEMBER=member-name2...];
CLUSTER CREATE cluster-tablename MEMBER=member-name1[, MEMBER=member-name2...][options];
CLUSTER DESTROY cluster-tablename;
CLUSTER FIX member-table-name;
CLUSTER LIST cluster-tablename [/VERBOSE][OUT=SAS-dataset-name];
CLUSTER MODIFY cluster-tablename MINMAXVARLIST=(var1 var2 ...);
CLUSTER REMOVE cluster-tablename MEMBER=member-name1
[, MEMBER=member-name2...];
CLUSTER REPLACE cluster-tablename OLDMEMBER=member-name
NEWMEMBER=member-name;
CLUSTER UNDO cluster- tablename;
CONSTRAINT ADD table-name; where where-clause-expression;
CONSTRAINT DESCRIBE table-name;
CONSTRAINT REMOVE table-name;
DELETE ACL [options];
LIST ACL [options];
MODIFY ACL [options];
OPER [options];
QUIT;
SET USER user-ID [port-number];
SET USER/LOCKING [user-ID threadID=number];
SHOWLIBNAME [options];
SPDSCMD 'command';
TRUNCATE table-name;
Last updated: February 3, 2017