I thought of using CAT but did not like that for my purposes. ... View more

I don't really know.  SPSS has this syntax  COUNT Count4J=PSTATE_ADVEN_r FUN POWER(4).   From what I can tell it does this, for every entry of a 4 in the variable list count.  I will have to confirm by running in SPSS and the code below in SAS to compare the results. if PSTATE_ADVEN_r=4 and FUN^=4 and POWER^=4 then count4J=1; else if PSTATE_ADVEN_r^=4 and FUN=4 and POWER^=4 then count4J=1; else if PSTATE_ADVEN_r^=4 and FUN^=4 and POWER=4 then count4J=1; else if PSTATE_ADVEN_r=4 and FUN=4 and POWER^=4 then count4J=2; else if PSTATE_ADVEN_r^=4 and FUN=4 and POWER=4 then count4J=2; else if PSTATE_ADVEN_r=4 and FUN^=4 and POWER=4 then count4J=2; else if PSTATE_ADVEN_r=4 and FUN=4 and POWER=4 then count4J=3; ... View more

proc sort data=a;by common_surveyid; proc sort data=b;by common_surveyid;run;   data a_b;merge a(in=a) b(in=b); by common_surveyid; if a and not b; run; ... View more