DATA Step, Macro, Functions and more

Pulling data from different data sources

Accepted Solution Solved
Reply
Learner
Posts: 1
Accepted Solution

Pulling data from different data sources

I have list of product_id in excel at local drive. I would like to pull those product_id which data table stored in database.

Looking for suggestion how to pull data for this condition where list keep in local while data stored in database.


Accepted Solutions
Solution
‎11-26-2017 09:20 PM
Super User
Super User
Posts: 9,855

Re: Pulling data from different data sources

Posted in reply to rachelimcs

Import the data from Excel, then use the dataset you create in a where clause something like:

where product_id in (select product_id from import_excel);

Without any furher information on what you have done, how you import the excel file, or how you connect to the db its hard to say.

View solution in original post


All Replies
Solution
‎11-26-2017 09:20 PM
Super User
Super User
Posts: 9,855

Re: Pulling data from different data sources

Posted in reply to rachelimcs

Import the data from Excel, then use the dataset you create in a where clause something like:

where product_id in (select product_id from import_excel);

Without any furher information on what you have done, how you import the excel file, or how you connect to the db its hard to say.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 139 views
  • 2 likes
  • 2 in conversation