How to search for a string between delimiters

ChickenLittle — Wed, 19 Apr 2023 23:17:58 GMT

Hi,

I have a field with a string of numbers separated by semicolons. I want to check if any of the numbers between the semicolons in this field is a match to what I am looking for. I know I can use "index" or "find," but it may give a false positive if it is a small number within a larger number. For example, if I have a field that contains 123;654;89 and I want to know if it contains '54', I do not want a false positive since 54 is in 654. How can I do this?

Example of what I have:

Obs StrgOfNum

1 934;54;1234

2 123;6542;89

What I want is to know if the number 54 is in any of the observations:

Obs

1 <---Should return a positive output indicated it is in this observations

2 <---Should return a negative output indicating it is not in this observations

Re: How to search for a string between delimiters

SASKiwi — Wed, 19 Apr 2023 23:55:47 GMT

data have;
   string = '934;54;1234';
   found = findw(string, '54');
   output;
   put _all_;
   string = '123;6542;89';
   found = findw(string, '54');
   output;
  put _all_;
run;

Re: How to search for a string between delimiters

ChickenLittle — Thu, 20 Apr 2023 00:09:44 GMT

THANKS!!!

topic Re: How to search for a string between delimiters in SAS Programming

How to search for a string between delimiters

Re: How to search for a string between delimiters

Re: How to search for a string between delimiters