Date: Tue, 4 Nov 2003 16:11:16 -0000
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Ben Powell <Ben.powell@CLA.CO.UK>
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:
Ben Powell, Data Analyst
Copyright Licensing Agency Ltd (CLA) - <http://www.cla.co.uk/>
Tel: +44 7631 5532 Fax: +44 7631 5500
Whilst the above is believed to be correct, it is provided for
only and should not be relied on. It does not constitute legal advice
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
relying on information contained in this email.