topic How to remove characters in character value in SAS Programming

How to remove characters in character value

knveraraju91 — Fri, 13 Jan 2017 00:03:37 GMT

Dear,

In my data the following values present. I need to remove characters in parenthesis in the chracter value. Please help. Thank you

data

ID value

1 0.10 (00 min) hours post-dose

1 2 (pre-2nd dose) (-2 min) hours post-dose

1 Pre-dose

output needed

id value

e
1 0.10 HOURS POST-DOSE
1 2 HOURS POST-DOSE

1 Pre-dose

Re: How to remove characters in character value

Patrick — Fri, 13 Jan 2017 00:26:26 GMT

As long as you don't have brackets in brackets the following should do the job:

data have;
 infile datalines truncover dlm='|';
 input ID:$1. value $100.;
 datalines;
1|0.10 (00 min) hours post-dose
1|2 (pre-2nd dose) (-2 min) hours post-dose
1|Pre-dose
;
run;

data sample;
 set have;
 length value_want $100;
 value_want=prxchange('s/\s*\(.*\)\s*/ /oi',-1,value);
run;