02-28-2014 05:35 AM
I am working with sas data management studio.I got a requirement like this.Thge records which are matching with given input need to be shown in output.For example if i just enter smith as input it should retrieve the records having smith,smithy,smithi,smit.I used external data provider and sql lookup to look in the database table.Kindly anyone help on this or this can be done in any way.
Your help is highly appreciated.
Thanks in advance.
03-04-2014 12:12 PM
This should be answered in this link:
I created an example using the route I suggested and the one you mentioned. Everything worked as expected. See screenshots for a walkthrough:
Sample Process job with Match Code Creation and Test Data Jobs:
Match Code creation, insert into database:
Test with sample data (3 names):
Match code generation of the 3 sample names:
SQL Lookup into database using match codes created and results shown (Left 2 highlighted columns are my test data, right highlighted column are the matches returned from the database):
SQL Lookup dialog box:
Let me know if this helps,