https://communities.sas.com/t5/SAS-Programming/Need-help-in-finding-at-least-one-match-from-the-group/m-p/886553#M350313 TID. NID. Addr1. Addr2. Srvc_addr<BR />45C 123. 1 fox ln. Suit 5. 1 fox ln Suit 5<BR />51A. 234. 21 dey rd. Bruns. 21 dey rd Bruns<BR />51A. 234. 21 Dey rd. Bruns. 66 Mac rd Cran<BR />51A. 234. 21 dey rd. Bruns. St 2 app dr NC<BR />58H. 378. 9 Horse ln. Garth. 88. Yard Bost<BR />58H. 378. 9 Horse ln. Garth. 2 abc rd connect<BR />58H. 379. 9 Horse ln. Garth. 9 Horse ln Garth<BR /><BR />Groupby TID and NID if not addr1+addr2 match with any one srvc_addr, then output that TID,NID<BR /><BR />Appreciate your support Wed, 26 Jul 2023 22:31:40 GMT cm3 2023-07-26T22:31:40Z https://communities.sas.com/t5/SAS-Programming/Need-help-in-finding-at-least-one-match-from-the-group/m-p/886553#M350313 TID. NID. Addr1. Addr2. Srvc_addr<BR />45C 123. 1 fox ln. Suit 5. 1 fox ln Suit 5<BR />51A. 234. 21 dey rd. Bruns. 21 dey rd Bruns<BR />51A. 234. 21 Dey rd. Bruns. 66 Mac rd Cran<BR />51A. 234. 21 dey rd. Bruns. St 2 app dr NC<BR />58H. 378. 9 Horse ln. Garth. 88. Yard Bost<BR />58H. 378. 9 Horse ln. Garth. 2 abc rd connect<BR />58H. 379. 9 Horse ln. Garth. 9 Horse ln Garth<BR /><BR />Groupby TID and NID if not addr1+addr2 match with any one srvc_addr, then output that TID,NID<BR /><BR />Appreciate your support Wed, 26 Jul 2023 22:31:40 GMT https://communities.sas.com/t5/SAS-Programming/Need-help-in-finding-at-least-one-match-from-the-group/m-p/886553#M350313 cm3 2023-07-26T22:31:40Z https://communities.sas.com/t5/SAS-Programming/Need-help-in-finding-at-least-one-match-from-the-group/m-p/886569#M350321 <P>In order to get the best help with your question, I would post your data as a working data step and use full English sentences to explain the problem and desired output.&nbsp;</P> Thu, 27 Jul 2023 04:06:05 GMT https://communities.sas.com/t5/SAS-Programming/Need-help-in-finding-at-least-one-match-from-the-group/m-p/886569#M350321 HB 2023-07-27T04:06:05Z