SPDO Procedure
- Syntax
Procedure SyntaxPROC SPDO StatementADD ACL StatementCLUSTER ADD StatementCLUSTER CREATE StatementCLUSTER DESTROY StatementCLUSTER FIX StatementCLUSTER LIST StatementCLUSTER MODIFY StatementCLUSTER REMOVE StatementCLUSTER REPLACE StatementCLUSTER UNDO StatementCONSTRAINT ADD StatementCONSTRAINT DESCRIBE StatementCONSTRAINT REMOVE StatementDELETE ACL StatementLIST ACL StatementLIST USERS StatementLIST USERS/LOCKING StatementMODIFY ACL StatementOPER StatementREFRESH DOMAINS StatementREFRESH PARMS StatementSET ACLTYPE StatementSET ACLUSER StatementSET MODE OPER StatementSET USER StatementSET USER/LOCKING StatementSHOWLIBNAME StatementSPDSCMD StatementSPDSMAC StatementTRUNCATE Statement - Overview
- Concepts
- Examples
CLUSTER UNDO Statement
Reverts a cluster table back to its unbound tables.
| Requirement: | You must have Control access to the cluster table to undo it. |
Syntax
CLUSTER UNDO cluster-
table-name;
Arguments
cluster-tablename
specifies the name of an existing cluster table to undo.
Details
Use CLUSTER UNDO when
you want to destroy the metadata that is associated with a cluster,
but want to keep the source tables.
Example
This CLUSTER UNDO statement
reverts the cluster Sales_History back to its original tables. Undoing
the cluster frees you to create a new cluster table named Sales_History
with a new set of member tables. Meanwhile, the original tables continue
to exist.
proc spdo library=libref;
cluster undo Sales_History;
quit;Copyright © SAS Institute Inc. All Rights Reserved.
Last updated: February 3, 2017