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?

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,254

Re: Can you help me with PROC SPDO?

What about column order, names, labels and formats?

Are the tables in the same libref?

Data never sleeps
SAS Super FREQ
Posts: 8,740

Re: Can you help me with PROC SPDO?

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?

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.

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

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