example: Var 1 as full_address '123 ABC STEET APT 305 MINNEAPOLIS MN 55332' and '333 5TH ST #3 SAINT PAUL 55343' Var 2 as city 'EDINA' and 'SAINT PAUL' if city exist in full_address, output the result Below are few codes I tried didn't work. data MATCHING_CITY; set ADDR_DATA; if index(FULL_ADDRESS, CITY) > 0 then do; output; end; run; data MATCHING_CITY; set ADDR_DATA; if find(FULL_ADDRESS, CITY) > 0 then do; output; end; run; data MATCHING_CITY; set ADDR_DATA; /*Initialize match flag*/ Match_flag = 0; /* Iterate through each city in CITY */ do i = 1 to countw(CITY, ' '); home_city = scan(CITY, i, ' '); /* Check if home_city exists within cactus_ben_nm_addr_comb_cpr */ if findw(FULL_ADDRESS, home_city, ' ', 'i') > 0 then do; /* Match found */ Match_flag=1; leave; end; end; drop home_city i; /* Drop temporary variables */ run; before I proceed these code I already, trim, upcase, compbl, compress the data.
... View more