Help using Base SAS procedures

Can you help me with PROC SPDO?

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 81
Accepted Solution

Can you help me with PROC SPDO?

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 ?


Capture.JPG

Accepted Solutions
Solution
‎02-08-2013 02:09 AM
Frequent Contributor
Posts: 81

Re: Can you help me with PROC SPDO?

Posted in reply to damanaulakh88

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

View solution in original post


All Replies
Super User
Posts: 5,437

Re: Can you help me with PROC SPDO?

Posted in reply to damanaulakh88

What about column order, names, labels and formats?

Are the tables in the same libref?

Data never sleeps
SAS Super FREQ
Posts: 8,868

Re: Can you help me with PROC SPDO?

Posted in reply to damanaulakh88

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

Solution
‎02-08-2013 02:09 AM
Frequent Contributor
Posts: 81

Re: Can you help me with PROC SPDO?

Posted in reply to damanaulakh88

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

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 699 views
  • 0 likes
  • 3 in conversation