04-21-2014 05:29 AM
I have an Address column which has 50,000 rows in it. The Address column is too lengthy and unstructured which has colony and area name mentioned in it.
Is it possible to pick a word and draw a graph? say for example select the word ''colony'' and make a bar graph by sales amount.
It would be helpful to explore location wise business if this option exists.
04-21-2014 06:52 AM
There are a number of ways (functions) that you can search a text string for a sub-string or word using SAS.
The FINDW function seems a likely candidate.