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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.