Member Table Requirements for Creating Dynamic Cluster Tables

Overview of Table Requirements

When you create a dynamic cluster table, all of the member tables must have matching table, variable, and index attributes. If there are attribute mismatches, the dynamic cluster table is not created, and SPD Server displays the following error message:

ERROR: Member table not compatible with other cluster members. Compare CONTENTS.

A more detailed error message is written to the SPD Server log. The SPD Server log lists which attribute is mismatched in the member table. All of the member table attributes that are described in the following topics must match in order for SPD Server to successfully create a dynamic cluster table.

Table Attributes
Variable Attributes
Index Attributes

Table Attributes

The following table attributes must match in all member tables to successfully create a dynamic cluster table:

CONSTRAINT

where constraint

DISKCOMP

compression algorithm

DSORG

data set organization

DS_ROLE

data set option for ROLE

DSTYPE

SAS data-set type

ENCODING_CEI

encoding CEI for NLS (for compressed tables)

FLAGS

compressed data set
encrypted data set
backup data set
NLS variables in data set
MINMAXVARLIST variables in data set
SAS encryption password in data set

IOBLOCKSIZE

I/O block size

IOBLOCKFACTOR

I/O block factor

LANG

data set language tag

LTYPE

data set language type tag

NINDEXES

number of indexes

NVAR

number of columns

OBSLEN

observation record length

SASPW

SAS encryption password

SEMTYPE

data set semantic type

Variable Attributes

The following variable attributes must match in all member tables to successfully create a dynamic cluster table:

NAME

variable name

LABEL

variable label

NFORM

variable format

NIFORM

variable informat

NPOS

variable offset in record

NVARO

variable number in record

NLNG

variable length

NPREC

variable precision

FLAGS

NLS encoding supported
MINMAXVARLIST variable

NFL

format length

NFD

format decimal places

NIFL

informat length

NIFD

informat precision

NSCALE

scale for fixed-point decimal

NTATTR

variable type attributes

TYPE

variable type

SUBTYPE

variable subtype

SORT

variable sorted status

NTYPE2

variable extended type code

Index Attributes

The following index attributes must match in all member tables to successfully create a dynamic cluster table:

NAME

index name

TYPE

index type

KEYFLAGS

unique index
nomiss index

LENGTH

index length

NVAR

number of variables in index

NVAR0

variable number in index