Hi all, I have a large SAS dataset with >100k records and it contains variables such as: forename, surname, company, email address...etc. I would like to search for a particular word (example 'TSE') in ANY of the variables and keep these records only. How do I go about writing this? I tried some code like the below, but it only returns records for one variable (i.e surname). data want; set have (where=(prxmatch("/\b(TSE)\b/io", surname))); run; Any help would be greatly appreciated. Cheers, Pete
... View more