topic Re: remove text inside brackets including brackets in SAS Programming

remove text inside brackets including brackets

SASPhile — Thu, 12 Jul 2018 20:28:32 GMT

raw data

abc(123)
(123)abc(pqr)

How to remove text inside brackets including brackets so the final data is below:
final data
abc
abc

Re: remove text inside brackets including brackets

art297 — Thu, 12 Jul 2018 21:30:59 GMT

The following should work:

data raw;
  informat text $80.;
  input text &;
  cards;
abc(123)
(123)abc(pqr)
;

data want;
  set raw;
  want = prxchange('s/\(([^\)]+)\)//i', -1, text);
run;

Art, CEO, AnalystFinder.com