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 ?
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
What about column order, names, labels and formats?
Are the tables in the same libref?
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
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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.