09-28-2016 07:27 AM
I am trying code certain retailer chains, predefined in my system from some store names. The store names contain the type of retailer, wherefrom i need to code the retailer chain. For example, there are multiple retail chains like Pick and Pay Mini, Pick and Pay Super, Shoprite, Shoprite Liqor etc.
The store names will by like PNP Mini ABC, Shoprite Liq XYZ and so on. So basically I need to code such that the system when comes across key words like shoprite it'll code it as SPR, for Shoprtie Liq it'll code SPL and so on, according to the store name
How can it read through strings and look for key words and throw appropriate code for it?
09-28-2016 07:43 AM
To check for substrings or words contained in a string, look for the index() or findw() functions.
09-28-2016 07:54 AM
If you have additional and similar requirements, you might want to look at SAS Data Management Studio, which has this as a core functionality.