Date:         Wed, 8 Jan 2003 16:57:11 -0500
Reply-To:     "John J Genzano, III" <jgenzano@GENZANO.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "John J Genzano, III" <jgenzano@GENZANO.COM>
Subject:      Re: Question on Search of record using SAS
Comments: To: Action Man <wollo_desse@HOTMAIL.COM>
In-Reply-To:  <F114ieX6xNhLWVz7Zy800023eb1@hotmail.com>
Content-Type: text/plain; charset="us-ascii"

  Where Age eq 25 and Frst_Name contains "Mike" and Scnd_Name like
"Musse_"
    and State eq " ";



John J Genzano, III
Principal Consultant
Genzano Software Consulting
610-212-6111
609-822-0211
SAS Certified Professional, V6


"The right to be heard does not automatically include the right to be
taken seriously." - Hubert Humphrey

________________________________________________________________________
_____

Earning $100,000 a year is just as easy as earning $15,000 when you know
how!
www.quickinfo247.com/7663993




-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
Action Man
Sent: Wednesday, January 08, 2003 4:02 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Question on Search of record using SAS


Question on Search of record using SAS

I have about a million records which holds the following sample
variables

Frst_Name  Scnd_Name  Age   Sex   street_Address  City   State   Zip.

I need to search for the record according to the following rules:

  If Age = 25 and if Frst_Name contains "Mike" and Scnd_Name like
"Musse"
and State is null.

How do I retrieve this record in SAS?

Thank you in Advance,
Wollo





_________________________________________________________________
STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
http://join.msn.com/?page=features/junkmail