I assume that what you have are SAS text variables that contain carriage returns and/or linefeeds. To extract the relevant lines from that, you could try something like this (assuming your initial variable is called TEXT, and the found lines will be in the variable LINE):
data want;
set have;
prxid=prxparse('/[^\r\l]*carbapenem[^\r\l]*/i');
pos=1;
do until(0);
call prxsubstr(prxid,text,pos,len);
if pos=0 then leave;
line=substr(text,pos,len);
output;
pos+length;
end;
run;
... View more
