https://communities.sas.com/t5/SAS-Programming/Pulling-data-from-different-data-sources/m-p/415493#M101906 <P>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.</P><P>Looking for suggestion how to pull data for this condition where list keep in local while data stored in database.</P> Wed, 22 Nov 2017 12:48:44 GMT rachelimcs 2017-11-22T12:48:44Z https://communities.sas.com/t5/SAS-Programming/Pulling-data-from-different-data-sources/m-p/415493#M101906 <P>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.</P><P>Looking for suggestion how to pull data for this condition where list keep in local while data stored in database.</P> Wed, 22 Nov 2017 12:48:44 GMT https://communities.sas.com/t5/SAS-Programming/Pulling-data-from-different-data-sources/m-p/415493#M101906 rachelimcs 2017-11-22T12:48:44Z https://communities.sas.com/t5/SAS-Programming/Pulling-data-from-different-data-sources/m-p/415499#M101908 <P>Import the data from Excel, then use the dataset you create in a where clause something like:</P> <PRE>where product_id in (select product_id from import_excel); </PRE> <P>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.</P> Wed, 22 Nov 2017 13:14:48 GMT https://communities.sas.com/t5/SAS-Programming/Pulling-data-from-different-data-sources/m-p/415499#M101908 RW9 2017-11-22T13:14:48Z