Date: Wed, 1 Dec 2010 18:03:10 -0800
Reply-To: art297 <atabachneck@GMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: art297 <atabachneck@GMAIL.COM>
Subject: Re: A Match question. Thanks.
Content-Type: text/plain; charset=ISO-8859-1
Why don't you just use eq ? E.g.,
input var $;
where var eq "ABB";
On Dec 1, 4:49 pm, CC <chchanghe...@gmail.com> wrote:
> Hello all,
> I have a question regarding the matching procedure. The are two
> companies for instance:
> For example, if I want to keep ABB and use the "contains" or "index"
> function to search for variables that contains "ABB", I will still
> have to keep observations having ABBOTT since it also contains "ABB"
> So, my code will like this.
> data want;
> set old;
> where var contains "ABB"; /* or I use if index(var, "ABB") > 0*/
> Using this code, I will not only get observations having "ABB" but
> also observations having "ABBOTT". Is there anyway I can do to only
> keep observations having "ABB"? Thanks a lot!