Hi All,
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.
Sandeep,
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,
-shawn
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.