how to keep part of a string

[HitmonTran]

Hi,

I have a value and want to exclude anything in "()"

data:

test_code
Aspartate amino transferase (AST, SGOT)
Alkaline phosphatase (ALP)
Blood urea nitrogen (BUN)

want:

test_code
Aspartate amino transferase 
Alkaline phosphatase 
Blood urea nitrogen

[PGStats · Accepted solution]

data have;
length str $100;
input str &;
datalines;
Aspartate amino transferase (AST, SGOT)
Alkaline phosphatase (ALP)
Blood urea nitrogen (BUN)
;

data want;
set have;
new_str = prxChange("s/\([^)]*\)//", 1, str);
run;

[SASKiwi]

If it is always on the end:

data want;
  text = 'Aspartate amino transferase (AST, SGOT)';
  text_want = substr(text, 1, indexc(text, '(') - 1);
  put _all_;
run;

[Ksharp]

data have;
length str $100;
input str &;
datalines;
Aspartate amino transferase (AST, SGOT)
Alkaline phosphatase (ALP)
Blood urea nitrogen (BUN)
;

data want;
set have;
new_str = prxChange("s/\(.+?\)//", 1, str);
run;