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
Content-Type: text/plain; charset="us-ascii"
Where Age eq 25 and Frst_Name contains "Mike" and Scnd_Name like
and State eq " ";
John J Genzano, III
Genzano Software Consulting
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
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
Sent: Wednesday, January 08, 2003 4:02 PM
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
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
and State is null.
How do I retrieve this record in SAS?
Thank you in Advance,
STOP MORE SPAM with the new MSN 8 and get 2 months FREE*