topic finding text with quotes in SAS Programming

finding text with quotes

kalbo — Mon, 10 Feb 2025 16:18:01 GMT

Hi I have a data set with text from a log file.

I have a variable called TEXT:

TEXT

put 'ERROR' blah blah blah

put "ERROR:" blah blah blah

var='ERROR' blah blah blah

var="ERROR" blah blah blah

I need to indentify cases where there is put followed by ERROR (in quotes) and cases where there is an = sign followed by ERROR (in quotes).

I was thinking of using index but thought PRXMATCH might be better due to the quote marks.

Re: finding text with quotes

PaigeMiller — Mon, 10 Feb 2025 16:28:46 GMT

data want;
    set have;
    if find(text,"put 'ERROR'")>0 or find(text,'put "ERROR"')>0
        or find(text,'="ERROR"')>0 or find(text,"='ERROR'")>0 then ... 
    ;
run;

I didn't finish the "then ..." part of the code, whatever goes there is up to you.

Re: finding text with quotes

quickbluefish — Mon, 10 Feb 2025 17:00:00 GMT

You could try this with PRXMATCH (slight edit to deal with the optional colon):

data test;
infile cards dsd truncover firstobs=1 dlm=',';
length logstuff $100;
input logstuff;
cards;
put 'ERROR' blah blah blah
put "ERROR-" blah blah blah
put "ERROR:" blah blah blah
var='ERROR' blah blah blah
var="error" blah blah blah
something else
put ERROR
var=error
putERROR
;
run;

proc print data=test; run;

data want;
set test;
ismatch=0;
if prxmatch("m/^(put\s+|var=)\'error:?\'\s*/i",tranwrd(logstuff,'"',"'")) then ismatch=1;
run;

proc print data=want; run;