topic Re: Can you help me with PROC SPDO? in SAS Procedures

Can you help me with PROC SPDO?

damanaulakh88 — Tue, 05 Feb 2013 07:48:54 GMT

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 ?

Re: Can you help me with PROC SPDO?

LinusH — Tue, 05 Feb 2013 08:26:46 GMT

What about column order, names, labels and formats?

Are the tables in the same libref?

Re: Can you help me with PROC SPDO?

Cynthia_sas — Wed, 06 Feb 2013 14:27:04 GMT

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

Re: Can you help me with PROC SPDO?

damanaulakh88 — Fri, 08 Feb 2013 07:09:02 GMT

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