topic Re: external data provider in SAS Data Management

external data provider

sandeep_reddy — Fri, 28 Feb 2014 10:35:36 GMT

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.

Re: external data provider

Patrick — Mon, 03 Mar 2014 10:06:34 GMT

See https://communities.sas.com/message/199139#199139

Re: external data provider

skillman — Tue, 04 Mar 2014 17:12:13 GMT

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