topic Re: Extracting specific information from rows in SAS Programming

Extracting specific information from rows

SarahW13 — Mon, 09 Sep 2019 07:40:11 GMT

I have a dataset in which each row is a long block of text, and I need to extract specific information from each row.

Below is an example:

id Text

1 Physical Exam. Vital Signs. BP: 134/93

2 Patient's physical exam was notable for BP of 142/100

3 Physical Exam. BP: 100/80

Below is what I need:

id Text

1 BP: 134/93

2 BP of 142/100

3 BP: 100/80

Any advice?

Re: Extracting specific information from rows

PeterClemmensen — Mon, 09 Sep 2019 07:59:06 GMT

Do something like this

data have;
input id Text :$200.;
infile datalines4 dlm=',';
datalines;
1,Physical Exam. Vital Signs. BP: 134/93
2,Patient's physical exam was notable for BP of 142/100
3,Physical Exam. BP: 100/80
;

data want;
    set have;
    NewString=substr(Text, index(Text, 'BP'));
run;

Re: Extracting specific information from rows

Jagadishkatam — Mon, 09 Sep 2019 08:31:50 GMT

Alternatively with prxchange function

data have;
input id Text&$100.;
text=prxchange('s/(.*)(bp.*)/$2/i',-1,text);
datalines4;
1 Physical Exam. Vital Signs. BP: 134/93
2 Patient's physical exam was notable for BP of 142/100
3 Physical Exam. BP: 100/80
;;;;

Re: Extracting specific information from rows

Ksharp — Mon, 09 Sep 2019 13:39:28 GMT

data have;
input id Text :$200.;
infile datalines4 dlm=',';
datalines;
1,Physical Exam. Vital Signs. BP: 134/93
2,Patient's physical exam was notable for BP of 142/100
3,Physical Exam. BP: 100/80
;

data want;
    set have;
    p=prxmatch('/\bBP\b/i',text);
    if p then NewString=substr(Text, p);
run;

proc print;run;

Re: Extracting specific information from rows

ballardw — Mon, 09 Sep 2019 15:01:21 GMT

@SarahW13 wrote:

I have a dataset in which each row is a long block of text, and I need to extract specific information from each row.

Below is an example:

id Text

1 Physical Exam. Vital Signs. BP: 134/93

2 Patient's physical exam was notable for BP of 142/100

3 Physical Exam. BP: 100/80

Below is what I need:

id Text

1 BP: 134/93

2 BP of 142/100

3 BP: 100/80

Any advice?

is BP always the last item entered? Is it always recorded with the / dividing the measurements?

Re: Extracting specific information from rows

alexpat — Mon, 09 Sep 2019 21:49:42 GMT

data cardiac;
input id Text :$200.;
infile datalines4 dlm=',';
datalines;
1,Physical Exam. Vital Signs. BP: 134/93
2,Patient's physical exam was notable for BP of 142/100
3,Physical Exam. BP: 100/80
;

data strepto;
set cardiac;
NewString=substr(Text, index(Text, 'BP'));
run;

Re: Extracting specific information from rows

alexpat — Mon, 09 Sep 2019 21:52:10 GMT

Rows 1-3

Total rows: 3Total columns: 3

Text

NewString

Physical Exam. Vital Signs. BP: 134/93

BP: 134/93

Patient's physical exam was notable for BP of 142/100

BP of 142/100

Physical Exam. BP: 100/80

BP: 100/80

Re: Extracting specific information from rows

alexpat — Mon, 09 Sep 2019 22:02:43 GMT

data sle;
set autoimmun;
p=prxmatch('/\bBP\b/i',text);
if p then NewString=substr(Text, p);
run;

Thanks Ksharp, another way to estract ///