remove the phone number value

cho16 — Wed, 22 Apr 2020 23:02:31 GMT

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

3 AC980

4 BH005

Thanks for your help.

Re: remove the phone number value

novinosrin — Wed, 22 Apr 2020 23:21:26 GMT


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;

topic Re: remove the phone number value in SAS Programming

remove the phone number value

Re: remove the phone number value