remove the phone number value

[cho16]

Hi ,

I have a column called USRFLD and it has all the code values like BH003, AC980 etc.. But unfortunately there is a data issue and it populates the phone number for few rows. I need to remove those records .

ID   USRFLD

1     BH003

2     780-000-000

3     AC980

4     BH005

5     780-000-000

want:

ID   USRFLD

1     BH003

2    

3     AC980

4     BH005

5    

Thanks for your help.

[novinosrin · Accepted solution]

data have;
input ID   USRFLD :$12.	;
cards;
1     BH003
2     780-000-000
3     AC980
4     BH005
5     780-000-000
;
/*To remove the record*/
data want;
 set have;
 where not prxmatch('/(\d{3}-){2}\d{3,4}/', USRFLD);
run;

/*To change to blank*/
data want;
 set have;
 USRFLD=prxchange('s/(\d{3}-){2}\d{3,4}/ /', -1, USRFLD);
run;