Date:         Thu, 12 Aug 2004 13:35:18 -0500
Reply-To:     Gary Ross <gary_ross@MGIC.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Gary Ross <gary_ross@MGIC.COM>
Organization: http://extra.newsguy.com
Subject:      Re: Finding a substring in a char() field
Content-Type: text/plain; charset=us-ascii

BobbyG wrote:
>
> If I'm looking for a substr() within a character field in, say, a
> FoxPro table, I can simply query, e,g, "for 'FEE ADJ'$merchant", and
> it'll turn up any records where the string 'FEE ADJ' is anywhere in
> the field, irrespective of beginning position.
>
> Does SAS have a similar capability?
>
> Best -
>
> Bobby Gladd
> FNBM Risk Management
> bobbyg@bgladd.com

Try the index and/or indexc SAS functions.