Can you help me with PROC SPDO?

[damanaulakh88]

ERROR: Member table not compatible with other cluster members. Compare CONTENTS.<TABLENAME> TABLE:FLAGS.

I have checked all the flags with compatible members as well, but still this issue persists.

Can you please help me ?

[LinusH]

What about column order, names, labels and formats?

Are the tables in the same libref?

[Cynthia_sas]

Hi:

  If you search on support.sas.com with this search string (words from your error message):

member table not compatible cluster

  The first 3 hits mention this error message or one very like it. Have you looked at these Tech Support notes?

cynthia

[damanaulakh88 · Accepted solution]

Hi Cynthia,

Yes, i looked into the notes provided in that link, but somehow i was missing some options while creating a member table and below were the options which solved my purpose:-

OPTION LOCALE=;
options compress=yes;
%let SPDSDCMP=YES;
%let SPDSIASY=YES;

Hence after implementing these options i was able to get rid of the FLAGS and LOCALE problem.

/Daman