Draw Graph from Selection of Word - Is it Possible?

[sat_lr]

Hi All,

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.

- satlr

[data_null__]

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.

[sat_lr]

thanks very much. let me try it out.

satlr