topic find the character in a string which is other than in the list in SAS Programming

find the character in a string which is other than in the list

anandbillava — Mon, 12 Jun 2017 16:28:38 GMT

I am trying to find string which contains characters other than some set of characters. Is there any function available for that ?

for e.g. I want to find strings in which there are characters which is other than a-z or A-Z or _. Any thing other than this would be caught.

Please help.

Re: find the character in a string which is other than in the list

BrunoMueller — Mon, 12 Jun 2017 16:36:59 GMT

Check the list of functions, specifically FINDC function

There are also functions for regular expressions, they start with PRX...

Re: find the character in a string which is other than in the list

art297 — Mon, 12 Jun 2017 16:42:24 GMT

There are a number of possibilities.

The FINDC function, with the 'FK' modifiers, does exactly what you want. It's described at: http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a002264923.htm

F includes A-Z, a-z and underscore in the list of characters and K sets the function to only find characters that AREN'T in that list of characters.

Art, CEO, AnalystFinder.com

Re: find the character in a string which is other than in the list

anandbillava — Mon, 12 Jun 2017 16:41:41 GMT

Thank you Bruno. I tried to use prxmatch and findc. I am not able to suceed. I am trying to find characters which is not in the list which is making me difficult to achieve this. Its easy to find the characters in the list.

Re: find the character in a string which is other than in the list

kiranv_ — Mon, 12 Jun 2017 16:57:17 GMT

something like this

  data have;
      /* Use PRXPARSE to compile the Perl regular expression.    */
  
     val ='123abc';
	 output;
	 val ='bacde_bde';
	 output;
	 val='abcdef';
	 output;
	 val='abc-jj';
	 output;
run;

data want(drop=patternid);
set have;
 patternID = prxparse('/[^A-Za-z_]+/');
 if prxmatch(patternID, val)>0;
 run;

Re: find the character in a string which is other than in the list

anandbillava — Mon, 12 Jun 2017 17:01:37 GMT

Thank you all. I am able to do this using findc function.

Re: find the character in a string which is other than in the list

Tom — Mon, 12 Jun 2017 17:14:33 GMT

That is what the VERIFY() function does.

Re: find the character in a string which is other than in the list

Ksharp — Tue, 13 Jun 2017 13:27:45 GMT

data want;
set have;
 if prxmatch('/\W/', strip(val));
run;