topic How to remove the some charater in different positions? in SAS Programming

How to remove the some charater in different positions?

ybz12003 — Wed, 07 Jun 2017 13:07:39 GMT

Hello:

I would like to remove some charaters from different postions in the string. Please advice.

The data are list below:

lab_den_pcr_perf_1

mhh_cyto_tests_1__cfdna

nad_cert_30

nad_imag_find___abn_cort_gyr

And I would like to change them to:

lab_den_pcr_perf

mhh_cyto_tests__cfdna

nad_cert

nad_imag_find

Re: How to remove the some charater in different positions?

Reeza — Wed, 07 Jun 2017 13:23:59 GMT

What are the rules?

Re: How to remove the some charater in different positions?

kiranv_ — Wed, 07 Jun 2017 13:38:07 GMT

As per suggestion of @Reeza , please provide some information, so that someone call help you. I find regular expressions very helpful for this kind of scenarios

Re: How to remove the some charater in different positions?

Jagadishkatam — Wed, 07 Jun 2017 14:04:53 GMT

/*In the below case i am suppressing only the digits whereever they are located in the string*/




data have;
input text$100.;
cards;
lab_den_pcr_perf_1
mhh_cyto_tests_1__cfdna
nad_cert_30
nad_imag_find___abn_cort_gyr
;

data want;
set have;
new=prxchange('s/\d+//',-1,text);
run;

Re: How to remove the some charater in different positions?

ybz12003 — Wed, 07 Jun 2017 16:19:16 GMT

Thanks for the great suggestion. will looking into the prxchange function.