topic Re: Prxparse in SAS Programming

Prxparse

Kiteulf — Tue, 16 Mar 2021 11:53:48 GMT

I am trying to find data that is 7 digits long and start with the number 4.

data want;
if not prxId then prxId + prxParse("/\d{7}\/");
set CV_misscr14;
start = 1;
stop = length(aj_text);
call prxNext(prxID, start, stop, aj_text, pos, len);
do while (pos > 0);
    cmaenum = input(prxPosn(prxId, 1, aj_text), best.);
    output;
    call prxNext(prxID, start, stop, aj_text, pos, len);
    end;
/*drop prxId start stop pos len;*/
run;

What do I need to change here for it to search for that?

Re: Prxparse

Ksharp — Tue, 16 Mar 2021 12:31:41 GMT

data have;
input x $10.;
if prxmatch('/^4\d{6}$/',strip(x)) then found=1;
cards;
1234567890
3232ywrer67
4wewe786834
4586888
45678213
;

Re: Prxparse

FreelanceReinh — Tue, 16 Mar 2021 12:59:06 GMT

Hi @Kiteulf,

Your DO loop suggests that you anticipate the possibility of more than one match per value of aj_text. In this case just correct the regular expression to

/4\d{6}/

and the second argument of the PRXPOSN function to 0.

Then from, say,

aj_text='3.14159265358979323846264338327950288419716939937510582097494459230781640628620899862803482534211706'

you would obtain