Scanning or coalesce to find match in data

Q1983 — Wed, 02 Jun 2021 17:54:15 GMT

data have1;
 length loan_num $10
 	curr_phone $10
	;
	input loan_num curr_phone;
datalines;
2234110000 1111111111 
3400238190 9981111111 
2098766890 0 

;
run;

data have2;
 length loan_num $10
	phone1 $10 
	alt_phone $10
	bus_phone $10;
	input loan_num -- bus_phone;
datalines;
2234110000 1111111111 0 3333333333 
3400238190 3323333333 1098899999 0 
2098766890 0 2234444444 0  

;
run;

proc sql;
create table have3 as
select *,case when curr_phone in coalesce(phone1,alt_phone,bus_phone)
then 'Y' end as Phone_Match
from have1		a
left join have2	b
on a.loan_num=b.loan_num
;quit;

I am comparing two sets of data (have1 and have2) When I combine the two in have3 I tried to use a coalesce to look for a match between curr_phone(have1) and phone1,alt_phone or bus_phone.(have2) If there is a match with any of the three I want to designate with a 'Y'. When I try and use coalesce I get an error. Would I need to use some type of scan of all three phone numbers or am I just using coalesce incorrectly?

Re: Scanning or coalesce to find match in data

Reeza — Wed, 02 Jun 2021 18:05:58 GMT

WHICHC() function.

topic Scanning or coalesce to find match in data in SAS Programming

Scanning or coalesce to find match in data

Re: Scanning or coalesce to find match in data