NOTNAME Function

Searches a character string for an invalid character in a SAS variable name under VALIDVARNAME=V7, and returns the first position at which that character is found

Category: Character

Syntax

NOTNAME ( string <, start >)

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.

Details

The NOTNAME function does not depend on the TRANTAB, ENCODING, or LOCALE options.

The NOTNAME function searches a string for the first occurrence of any character that is not valid in a SAS variable name under VALIDVARNAME=V7. These characters are any except underscore (_), digits, and uppercase or lowercase English letters . If such a character is found, NOTNAME returns the position in the string of that character. If no such character is found, NOTNAME returns a value of 0.

If you use only one argument, NOTNAME 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.

NOTNAME 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.

Comparisons

The NOTNAME function searches a string for the first occurrence of any character that is not valid in a SAS variable name under VALIDVARNAME=V7. The ANYNAME function searches a string for the first occurrence of any character that is valid in a SAS variable name under VALIDVARNAME=V7.

Examples

The following example uses the NOTNAME function to search a string for any character that is not valid in a SAS variable name under VALIDVARNAME=V7.

 data _null_;     string='Next = _n_ + 12E3;';     j=0;     do until(j=0);        j=notname(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=5 c=  j=6 c==  j=7 c=  j=11 c=  j=12 c=+  j=13 c=  j=18 c=;  That's all

NOTNAME Function