ANYALPHA Function

Arguments

string

is the character constant, variable, or expression to search.

start

is an optional integer that specifies the position at which the search should start and the direction in which to search.

The results of the ANYALPHA function depend directly on the translation table that is in effect (see TRANTAB= System Option) and indirectly on the ENCODING and LOCALE system options.

The ANYALPHA function searches a string for the first occurrence of any character that is an uppercase or lowercase letter. If such a character is found, ANYALPHA returns the position in the string of that character. If no such character is found, ANYALPHA returns a value of 0.

If you use only one argument, ANYALPHA begins the search at the beginning of the string. If you use two arguments, the absolute value of the second argument, start, specifies the position at which to begin the search. The direction in which to search is determined in the following way:

• If the value of start is positive, the search proceeds to the right.

• If the value of start is negative, the search proceeds to the left.

• If the value of start is less than the negative length of the string, the search begins at the end of the string.

ANYALPHA returns a value of zero when

• the character that you are searching for is not found

• the value of start is greater than the length of the string

• the value of start = 0.

The ANYALPHA function searches a character string for an alphabetic character. The NOTALPHA function searches a character string for a non-alphabetic character.

The following example uses the ANYALPHA function to search a string from left to right for alphabetic characters.

data _null_;    
   string='Next = _n_ + 12E3;';  
   j=0;  
   do until(j=0);  
      j=anyalpha(string,j+1);  
      if j=0 then put +3 "That's all";  
      else do;          
         c=substr(string,j,1);  
         put +3 j= c=;  
      end; 
   end;
run;

The following lines are written to the SAS log:

   j=1 c=N
   j=2 c=e
   j=3 c=x
   j=4 c=t
   j=9 c=n
   j=16 c=E
   That's all

Copyright © 2007 by SAS Institute Inc., Cary, NC, USA. All rights reserved.