topic Re: How to compare two column strings which are almost same using LIKE or CONTAINS operator in SAS Programming

How to compare two column strings which are almost same using LIKE or CONTAINS operator

buddha_d — Mon, 16 Nov 2020 04:29:18 GMT

Dear SAS community,

I am trying to compare two columns which are almost same as shown below. If you look at the data carefully the sender is same as receiver (except that some of the rows have middle name etc). I have to code in a way where I can get the last record where the sender and receiver names don't match at all. This is the sample data of real time data. Please help me to find a solution. I tried using like operator and contains operator but of no use.

Thanks in advance

DATA have ;
INPUT sender $13. receiver$33.;
CARDS;
DON A ABROGS FOR FURTHER CREDIT: DON A ABROGS
ANTHONY BOGGS INFAVOR OF ANTHONY L BOGGS
TIM D BRUNS TIMOTHY BRUNS 
KEN V PAYE KENNETH V PAYE
ERICA PARIS ERICA N PARIS
JEFF WOOD JEFFORY WOOD
NICK PATEL CREDIT TO: 345678 (NICK PATEL)
JOEL NELSON TAMMY WOODWARDS
;
RUN;

I tried the following code and didn't get what I wanted. I need to see the last record (joel nelson and tammy woodwards) record as a result

proc sql;
	create table want as 
	select *
	from have 
	where compress(receiver) like '%'||compress(sender)||'%' 
		 
	; quit;

Re: How to compare two column strings which are almost same using LIKE or CONTAINS operator

buddha_d — Mon, 16 Nov 2020 05:30:44 GMT

DATA have ;
INPUT sender $13. receiver$33.;
CARDS;
DON A ABROGS  FOR FURTHER CREDIT: DON A ABROGS
ANTHONY BOGGS INFAVOR OF ANTHONY L BOGGS
TIM D BRUNS   TIMOTHY BRUNS 
KEN V PAYE    KENNETH V PAYE
ERICA PARIS   ERICA N PARIS
JEFF WOOD     JEFFORY WOOD
NICK PATEL    CREDIT TO: 345678 (NICK PATEL)
JOEL NELSON   TAMMY WOODWARDS
;
RUN;

sorry for unformatted data posting previously

Re: How to compare two column strings which are almost same using LIKE or CONTAINS operator

Ksharp — Mon, 16 Nov 2020 12:36:36 GMT

Check fuzz match functions like :
SPEDIS()
COMPLEV()
COMPGEN()

Re: How to compare two column strings which are almost same using LIKE or CONTAINS operator

buddha_d — Tue, 17 Nov 2020 13:38:18 GMT

Thanks Ksharp !! I will give it a try.