data one;
input bankname $1-20;
length bankname $20;
cards;
new york bank
new york bank.
NEW YORK bank
new york bnk
new yrk bank
ne york bank
neww york bank
nnew york bank
ew york bank
new york mets
;
run;
data two;
set one;
where bankname=*'new york bank';
run;
data three;
set one;
where soundex(bankname)=soundex('new york bank');
run;
data four;
set one;
banks=soundex(bankname);
test=soundex('new york bank');
run; Datasets two and three have no observations. Dataset four looks like this: new york bank, 562152, N62152 ... new york mets, 562532, N62152 I also tried it in a proc sql and had similar results. When I use =* or soundex on a variable, it does not output the leading character. When I use it on a constant, the output looks as I expect it to. What am I doing wrong? Thanks
... View more