SPDO Procedure

CLUSTER ADD Statement

Adds a member to an existing cluster table.

Requirements: You must have Control access to both the table and the cluster in order to add the table to the cluster.
The candidate table must be in the same domain as the cluster and have the same structure as other tables in the cluster. See Member Table Requirements for Creating Dynamic Cluster Tables in SAS Scalable Performance Data Server: User’s Guide.
Syntax
Arguments
Details
Example

Syntax

CLUSTER ADD cluster-tablename MEMBER=member-name1[, MEMBER=member-name2...];

Arguments

cluster-tablename

specifies the name of an existing cluster table.

MEMBER=member-name

specifies the name of one or more new member tables. To specify multiple tables, use multiple MEMBER= statements. The new member tables are appended to the end of the specified cluster table’s member list.

Alias MEM=

Details

The CLUSTER ADD statement is used to add members to a cluster table that was previously created with the CLUSTER CREATE statement. For more information, see CLUSTER CREATE Statement.
When a member table is added to a cluster, users that currently have that cluster open for reading will not see the new member. Changes to the cluster are not reflected until the cluster is reopened or opened after the CLUSTER ADD processing completes.

Example

This CLUSTER ADD example adds two member tables to the cluster named Sales_History. 
proc spdo library=libref;
cluster add Sales_History
mem=sales201607
mem=sales201608
quit;
Copyright © SAS Institute Inc. All Rights Reserved.
Last updated: February 3, 2017