removing unecessary data

[Ishwarkumar]

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)

[LinusH]

Use sql with a having count(seat_id) = 1 clause.

[RW9]

Proc sort with nodupkey option.  If you post a question, please ensure you post test data - in the form of a datastep, and what the output should look like.  Otherwise you will just get general answers which may or may not relate to your issue.