DATA Step, Macro, Functions and more

How to remove characters in character value

Reply
Super Contributor
Posts: 272

How to remove characters in character value

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

 

 

Respected Advisor
Posts: 3,887

Re: How to remove characters in character value

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;
Ask a Question
Discussion stats
  • 1 reply
  • 155 views
  • 1 like
  • 2 in conversation