proc sort data = large; by name; run; proc sort data = small; by person_name; run; data merged; retain name person_name; merge large(in= l) small(rename = (person_name=name) in = s); by name; length status$ 8; if s then do; person_name = name; if l then status = "match"; else status = "no match"; end; else do; person_name = ""; status = "no match"; end; run;
... View more