SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

external data provider

Reply
Contributor
Posts: 61

external data provider

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.

Respected Advisor
Posts: 4,173

Re: external data provider

Posted in reply to sandeep_reddy
SAS Employee
Posts: 85

Re: external data provider

Posted in reply to sandeep_reddy

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_lookup_1.jpg

Match Code creation, insert into database:

match_code_lookup_2.jpg

Test with sample data (3 names):

match_code_lookup_3.jpg

Match code generation of the 3 sample names:

match_code_lookup_4.jpg

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):

match_code_lookup_5.jpg

SQL Lookup dialog box:

match_code_lookup_6.jpg

Let me know if this helps,

-shawn

Ask a Question
Discussion stats
  • 2 replies
  • 270 views
  • 0 likes
  • 3 in conversation