|
Hiya,
I have 2 datasets that I am trying to match. One is a lookup table and one is a transaction table.
In common between the two tables is a keyword, however I need to not only exact match on the keyword but also broadmatch to append a classification.
For example in the Lookup table I have a keyword of "media planning group" this can match to any transaction as long as the 3 words ("media", "planning" and "group") appear within the transaction keyword in any order with any other characters eg mediaplanninggroup, media-planning group, media planning groups, communication media planninggroup etc
I have split out the keyword on the lookup table on the lookup table but I am unsure of how to match via this methodology as I have 95k on the lookup table so I can not hardcode all the options and I need to repeat the work.
If you could please point me in the right direction that would be great as I am new to SPSS but have being programming in SAS for many years.
Cheers,
Niki
---------------------------------
Yahoo! Photos NEW, now offering a quality print service from just 8p a photo.
|