INDEX Function

Searches a character expression for a string of characters

Category: Character

Syntax

INDEX ( source,excerpt )

Arguments

source

• specifies the character expression to search.

excerpt

• specifies the string of characters to search for in the character expression.

• Tip: Enclose a literal string of characters in quotation marks.

Details

The INDEX function searches source , from left to right, for the first occurrence of the string specified in excerpt , and returns the position in source of the string's first character. If the string is not found in source , INDEX returns a value of 0. If there are multiple occurrences of the string, INDEX returns only the position of the first occurrence.

Examples

SAS Statements	Results
a='ABC.DEF (X=Y)'; b='X=Y'; x=index(a,b); put x;	10

See Also

Functions:

• 'INDEXC Function' on page 590

• 'INDEXW Function' on page 591