https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Restricting-Excel-data-with-DB2-data/m-p/67082#M911 Complicated, yes. <span class="lia-unicode-emoji" title=":winking_face:">😉</span> <BR /> There is a Pivot-table from where the user is selecting some data. When (s)he has selected the data (s)he would like to compare one column of the selection with DB2 table to see which sells are not in the DB2 table. <BR /> <BR /> The DB2 table could have more than 65 000 rows, so I can't just 'bring it over' from mainframe. So I should be able to get the selected data from the excel table and transfer it to mainframe and exclude the data that is in DB2 and show the 'leftovers' on the excel sheet. Thu, 27 Aug 2009 07:23:34 GMT Virpi 2009-08-27T07:23:34Z https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Restricting-Excel-data-with-DB2-data/m-p/67080#M909 Is there a way for restricting rows on excel sheet by selecting those who are not present in DB2 table? <BR /> AMO Analyze Data / Compare is not giving the answer easily and the result is not what is wanted. <BR /> <BR /> Can we capsule selected area on excel sheet and call stored process and use the capsulated data as parameter? Wed, 26 Aug 2009 12:20:17 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Restricting-Excel-data-with-DB2-data/m-p/67080#M909 Virpi 2009-08-26T12:20:17Z https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Restricting-Excel-data-with-DB2-data/m-p/67081#M910 Please tell us more about this application.<BR /> From this brief information, I think this sounds a bit complicated. If you could the "original" data stored in DB2/SAS, you could create a view or a result set that could be displayed in AMO/Excel...?<BR /> <BR /> /Linus Thu, 27 Aug 2009 06:55:53 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Restricting-Excel-data-with-DB2-data/m-p/67081#M910 LinusH 2009-08-27T06:55:53Z https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Restricting-Excel-data-with-DB2-data/m-p/67082#M911 Complicated, yes. <span class="lia-unicode-emoji" title=":winking_face:">😉</span> <BR /> There is a Pivot-table from where the user is selecting some data. When (s)he has selected the data (s)he would like to compare one column of the selection with DB2 table to see which sells are not in the DB2 table. <BR /> <BR /> The DB2 table could have more than 65 000 rows, so I can't just 'bring it over' from mainframe. So I should be able to get the selected data from the excel table and transfer it to mainframe and exclude the data that is in DB2 and show the 'leftovers' on the excel sheet. Thu, 27 Aug 2009 07:23:34 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Restricting-Excel-data-with-DB2-data/m-p/67082#M911 Virpi 2009-08-27T07:23:34Z https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Restricting-Excel-data-with-DB2-data/m-p/67083#M912 Now I understand better your current situation, but not why. This look-up to DB2 seems like an data quality check-up? If so, I don't think this not best solved by some end-user application. I would prefer some data preparation where you could match your sales data on beforehand and present the complete result to the user (in a pivot).<BR /> /Linus Thu, 27 Aug 2009 13:51:50 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Restricting-Excel-data-with-DB2-data/m-p/67083#M912 LinusH 2009-08-27T13:51:50Z https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Restricting-Excel-data-with-DB2-data/m-p/67084#M913 You can use Copy To SAS Server (in the Active Data dropdown or menu in toolbar/ribbon) to save the selected Excel data as a SAS data set to your server, then run whatever comparison code you would like on the server. Thu, 27 Aug 2009 14:00:46 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Restricting-Excel-data-with-DB2-data/m-p/67084#M913 CaseySmith 2009-08-27T14:00:46Z