Hi everyone, I have a problem that I hope someone could help with. I'm fairly new to SAS (9.4) so I apologize if my description is not clear and does not use the appropriate SAS terminology. Here is the problem: I have 2 SAS data sets - data set A contains over 500 words and data set B contains over 10,000 complex character strings. I would like to write a program that will evaluate every word data set B to see if it exists in data set A. If it does, then replace the word with something else (the replacement is abritrary) and put the final result in data set C. For example, if the replacement word is HAT, then: Data Set A 1 CAR 2 DOG 3 MAN Data Set B 1 THE DOG RODE IN THE CAR WITH THE MAN 2 THIS CHEESEBURGER IS GREAT Data Set C 1 THE HAT RODE IN THE HAT WITH THE HAT 2 THIS CHEESEBURGER IS GREAT I've tried finding a solution to this problem in this message board and others but have not found a satisfactory solution. Any help will be greatly appreciated. Thanks in advance!
... View more