It works fine for me. What are you doing wrong? data HAVE(index=(GROUP)); input (NOTETEXT OBJECTID GROUP ) ($); ROW=_N_; cards; a 1 1 b 1 1 d 1 2 f 1 3 g 1 4 t 2 5 y 2 5 f 3 6 a 4 7 b 4 7 d 4 8 f 5 9 r 6 10 s 6 10 t 6 10 a 6 11 b 6 11 s 6 11 q 7 12 w 7 12 e 7 12 r 7 12 d 7 13 f 7 14 g 7 15 run; data PATTERNS; retain PATTERN ; length PATTERN $16; set HAVE; by GROUP; if first.GROUP then PATTERN=' '; PATTERN=cats(PATTERN,NOTETEXT); if last.GROUP then output; keep GROUP PATTERN; run; proc sql; create table WANT as select trans.* , case when COUNT>1 then 'Y' else 'N' end as REPEATED , pattern.PATTERN , PATTERN_NO , COUNT from HAVE trans ,PATTERNS pattern ,(select PATTERN , count(*) as COUNT , monotonic() as PATTERN_NO from PATTERNS group by PATTERN) count where trans.GROUP = pattern.GROUP and pattern.PATTERN = count.PATTERN order by ROW; quit; NOTETEXT OBJECTID GROUP ROW REPEATED PATTERN PATTERN_NO COUNT a 1 1 1 Y ab 1 2 b 1 1 2 Y ab 1 2 d 1 2 3 Y d 5 3 f 1 3 4 Y f 15 4 g 1 4 5 Y g 7 2 t 2 5 6 N ty 11 1 y 2 5 7 N ty 11 1 f 3 6 8 Y f 15 4 a 4 7 9 Y ab 1 2 b 4 7 10 Y ab 1 2 d 4 8 11 Y d 5 3 f 5 9 12 Y f 15 4 r 6 10 13 N rst 2 1 s 6 10 14 N rst 2 1 t 6 10 15 N rst 2 1 a 6 11 16 N abs 3 1 b 6 11 17 N abs 3 1 s 6 11 18 N abs 3 1 q 7 12 19 N qwer 4 1 w 7 12 20 N qwer 4 1 e 7 12 21 N qwer 4 1 r 7 12 22 N qwer 4 1 d 7 13 23 Y d 5 3 f 7 14 24 Y f 15 4 g 7 15 25 Y g 7 2     ... View more

Ah ok. This gives you the final required output   data have; length Column1 $200; input Column1 $ group; datalines; Benefits,verify 1 claims,verify,benefits,verify 2 inquiry,type 3 claims,verify 4 Benefits,verify,inquiry,type,Benefits 5 Benefits 6 Benefits 7 ; data want(keep=Column1 Part_Of_Group count); set have nobs=nobs; count=0; do _N_=1 to nobs; set have(rename=(Column1=compColumn1 group=compGroup)) point=_N_; if find(compColumn1, Column1, 'it') ne 0 & group ne compGroup & countw(Column1, ",")>1 then do; Part_Of_Group=compGroup; count+1; output; end; end; if count=0 & countw(Column1, ",")>1 then output; run; ... View more

data have; input Column1 $35. group; cards; Benefits,verify 1 claims,verify,benefits,verify 2 inquiry,type 3 claims,verify 4 ; run; proc sql; create table temp as select a.column1,b.group,count(*) as n from have as a , have as b where upcase(b.column1) contains upcase(strip(a.column1)) and a.group ne b.group group by a.column1; create table want as select * from temp union select column1,0,0 from have where column1 not in (select column1 from temp) ; quit; ... View more