Date:         Tue, 4 Nov 2003 16:11:16 -0000
Reply-To:     ben.powell@cla.co.uk
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Ben Powell <Ben.powell@CLA.CO.UK>
Organization: cla
Subject:      Scan Array for matches
Content-Type: text/plain; charset="us-ascii"

Dear SAS-L would be Perl users,

Not knowing Perl (or SAS apparently) how would I do this in SAS: I have
two datasets. set1 contains all items. set2 contains keywords from items
to be excluded. How do I scan through the full name field in set1
looking for items where the full name is like the keyword - the keyword
is effectively a substring?  What if there is more than one keyword, as
in keyword1 keyword2, etc.

I'm sorry I can't be more clear than this!

Here are some data examples:

set1 -

Name
test
test
test
meme
test
test
test

set2 -
keyword
me
other
other

Ben.

----------------
Ben Powell, Data Analyst
Copyright Licensing Agency Ltd (CLA) - <http://www.cla.co.uk/>
Tel: +44 7631 5532   Fax: +44 7631 5500
<mailto:ben.powell @cla.co.uk>

****
Whilst the above is believed to be correct, it is provided for
information
only and should not be relied on.  It does not constitute legal advice
and
if you have a specific problem you are strongly advised to consult a
solicitor or other appropriately qualified professional.  Neither myself

nor CLA hold itself out as an expert and neither can accept any
responsibility or liability for any loss or damage incurred as a result
of
relying on information contained in this email.