Dear all,
when I find all strings between (),[],and {} (such as <BR>, [FONT],{BODY},'A',"JUICE") and split them in a new variable
(for example, for the 'JUICE<BR>apple<footer>',I expect to add a blank between 'JUICE' and 'apple')
However,
the value
HARDY(FRNS.)'A'
cannot be processed by the code
I expect to get
| name | COMPANY_NAME_inB | COMPANY_NAME_noB |
| HARDY(FRNS.)'A' | FRNS. | HARDY |
| HARDY(FRNS.)'A' | A | HARDY |
However, I only get
| name | COMPANY_NAME_inB | COMPANY_NAME_noB |
| HARDY(FRNS.)'A' | A | HARDY(FRNS.) |
Could you please give me some suggestions?
data have ;
infile datalines truncover;
input name $100.;
datalines;
JUICE<BR>apple[footer]
juice <BR> apple
juice<BODY> 'apple'
<figure> "juice" LTD
HARDY(FRNS.)'A'
HAFSLUND 'B' (XSQ)
;
data want;
set have;
RegExID = prxparse('/<\w*>|\(\w*\)|\[\w*\]|\(\w*\)|"\w*"|''\w*''/');
start=1;
stop=length(name);
call prxnext(RegExID, start, stop, name, pos, length);
do while (pos > 0);
COMPANY_NAME_inB = substr(name, pos+1, length-2);
COMPANY_NAME_noB = prxchange('s/<\w*>|\(\w*\)|\[\w*\]|\(\w*\)|"\w*"|''\w*''/ /', -1, name);
output;
call prxnext(RegExID, start, stop, name, pos, length);
end;
drop RegExID pos length start stop;
run;
proc print data=want;
run;
Click image to register for webinar
