topic Re: Special searching - 2 letters after 4 numbers / 000 + 4 numbers? in SAS Programming

Special searching - 2 letters after 4 numbers / 000 + 4 numbers?

ybz12003 — Mon, 24 Feb 2020 19:18:15 GMT

Hi all,

I would like to do the following searching in my sample test dataset.

1. Searching 4 numbers + 2 letters afterwards

2. Searching any numbers starting with 000.

The result I am looking for is in the Find column.

data Text;
      infile datalines dsd;
  input TempID : $15. TempID_1 : $15.  TempID_2 : $15. TempID_3 : $15. TempID_4 : $15.   Find :  $10. ;
datalines;
1156 IL, 89__46, 88--53, , , 1156IL
1487-KM, __8956, _78-52__, Car 4632, , 1487KM
000-597, -1596_, 4113, , ,  000597
C_ _-1156, 4986__, 0_0-0_8, , , 0008
208, 8M _ O23, , , Car ID 7788 GH, 7788GH
HB_21156--, 89   66, 885 - 2, 5 5 5 9, 0056,  
;

Re: Special searching - 2 letters after 4 numbers / 000 + 4 numbers?

Reeza — Mon, 24 Feb 2020 20:03:59 GMT

Symbols don't seem to matter between the numbers/character? Is it only underscore and hyphen and spaces or are there possibly other separators that need to be ignored?

Re: Special searching - 2 letters after 4 numbers / 000 + 4 numbers?

ChrisNZ — Tue, 25 Feb 2020 03:03:00 GMT

Like this?

%* Finds 4 digits, then an optional non-word character, then 2 letters;

POS1 = prxmatch('/\d{4}\W?[a-zA-Z]{2]/' , TEMP_ID);

%* Finds 3 zeros then a series of one or more digit(s);

POS2 = prxmatch('/000\d+/' , TEMP_ID);

What do you do once you find these?

Re: Special searching - 2 letters after 4 numbers / 000 + 4 numbers?

andreas_lds — Tue, 25 Feb 2020 07:53:25 GMT

@ybz12003 The values in Find are not according with the description you have posted, please fix it.

Re: Special searching - 2 letters after 4 numbers / 000 + 4 numbers?

ybz12003 — Tue, 25 Feb 2020 18:22:54 GMT

Don't worry about it, I found the solution myself. Thanks for your help!