Desktop productivity for business analysts and programmers

removing unecessary data

Reply
Occasional Contributor
Posts: 18

removing unecessary data

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)

Esteemed Advisor
Posts: 5,198

Re: removing unecessary data

Use sql with a having count(seat_id) = 1 clause.
Data never sleeps
Esteemed Advisor
Esteemed Advisor
Posts: 7,222

Re: removing unecessary data

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.

Ask a Question
Discussion stats
  • 2 replies
  • 100 views
  • 0 likes
  • 3 in conversation