topic Re: how to keep part of a string in SAS Programming

how to keep part of a string

HitmonTran — Wed, 31 Mar 2021 22:16:31 GMT

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

Re: how to keep part of a string

PGStats — Wed, 31 Mar 2021 22:28:19 GMT

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;

Re: how to keep part of a string

SASKiwi — Wed, 31 Mar 2021 22:30:48 GMT

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;

Re: how to keep part of a string

Ksharp — Thu, 01 Apr 2021 11:22:04 GMT

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;