I have a list of company names and I would like to subtract the rows with certain company names and create a new file. As company names are given in capital (WALMART), lowercase(walmart), hyphen in the middle (Wal-Mart) or mixed with other words (WALMART SUPERMARKET), I need multiple words to include. Basically, I want the observations that contain 'WALMART' or any similar word in it.
Company
Walmart
WALMART
Wal-MART
WALMART SUPERMARKET
WALMART PHARMACY
I ran the code below, but it didn't work.
20 data all.walmart; 21 set all.retailstore; 22 if findw(company,'WALMART')>0; 23 if findw(company,'walmart')>0 ; 24 if findw(company,'Walmart')>0 ; 25 if findw(company,'Wal-mart')>0 ; 26 if findw(company,'WAL-MART')>0 ; 27 run;
... View more