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>
Subject: Re: Finding a substring in a char() field
Content-Type: text/plain; charset=us-ascii
> 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
Try the index and/or indexc SAS functions.