Thanks Chris.
The =: or In: operator doesn't seem to function in SQL, but here's how I did manage to reduce my error rate (not identifying a spanish surname the previous Dbase program did) from 3% to 1%.
I went to look at what surnames were being missed. It seemed that a pattern had emerged...
Here's the issue.
I have two files.
SANBEN is a listing of surnames in a place of interest.
HISPANIC80 is a listing of partial and full Hispanic surnames.
I'm currently trying to port over this surname analysis program into SAS from a very old version of DBASE.
The following code works...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.