Hello, I require assistance with comparing two variables in SAS and determining if there are any partial record matches. data have;
length VAR1 $100 VAR2 $100;
input VAR1 $ VAR2 $;
infile datalines dlm='|';
datalines;
1.DR. MORRISON|
1.MORRISON| ABCFG MORRISON
1.DR. MORRISON| MORRISON
1.DR. MORRISON| DR. WRIGHT
1. LA HOSPITAL| SAN DIEGO
; data want / Expected Result VAR1 VAR2 PARTIAL MATCH? 1.DR. MORRISON NO 1.MORRISON ABCFG MORRISON YES 1.DR. MORRISON MORRISON YES 1.DR. MORRISON DR.WRIGHT NO 1. LA HOSPITAL SAN DIEGO NO
... View more