https://communities.sas.com/t5/SAS-Enterprise-Guide/removing-unecessary-data/m-p/330110#M21934 Use sql with a having count(seat_id) = 1 clause. Mon, 06 Feb 2017 07:28:50 GMT LinusH 2017-02-06T07:28:50Z https://communities.sas.com/t5/SAS-Enterprise-Guide/removing-unecessary-data/m-p/330104#M21933 <P>I'm having a data. in that data, there are columns called seat_id and store_id. one seat_id is having multiple store_id. ( want to remove those seat_id which are having multiple stores)</P> Mon, 06 Feb 2017 06:38:16 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/removing-unecessary-data/m-p/330104#M21933 Ishwarkumar 2017-02-06T06:38:16Z https://communities.sas.com/t5/SAS-Enterprise-Guide/removing-unecessary-data/m-p/330110#M21934 Use sql with a having count(seat_id) = 1 clause. Mon, 06 Feb 2017 07:28:50 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/removing-unecessary-data/m-p/330110#M21934 LinusH 2017-02-06T07:28:50Z https://communities.sas.com/t5/SAS-Enterprise-Guide/removing-unecessary-data/m-p/330120#M21935 <P>Proc sort with nodupkey option. &nbsp;If you post a question, please ensure you post test data - in the form of a datastep, and what the output should look like. &nbsp;Otherwise you will just get general answers which may or may not relate to your issue.</P> Mon, 06 Feb 2017 09:19:13 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/removing-unecessary-data/m-p/330120#M21935 RW9 2017-02-06T09:19:13Z