Exploring, modeling, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Draw Graph from Selection of Word - Is it Possible?

Reply
Frequent Contributor
Posts: 85

Draw Graph from Selection of Word - Is it Possible?

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

Respected Advisor
Posts: 3,768

Re: Draw Graph from Selection of Word - Is it Possible?

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.

Frequent Contributor
Posts: 85

Re: Draw Graph from Selection of Word - Is it Possible?

thanks very much. let me try it out.

satlr

Post a Question
Discussion Stats
  • 2 replies
  • 255 views
  • 4 likes
  • 2 in conversation