During the booking process the resources enter the phone numbers of our clients however there are many instances where an incorrect phone number has been entered lets says "9999999999". <this is an india format with 10 digits and no country code>.

I have run proc freq on this data and can see there is approx 19.5% of the data which is incorrect i.e. in the format like "9999999999", "1111111111" etc which are written in varuous ways.

I need to delete this data and only keep the valid phone numbers.

running if delete statement would have done the trick however as i mentioned the ph number is written in various ways (all numeric).

Kindly suggest an easy way if possible. I am working on SAS developer.