topic Draw Graph from Selection of Word - Is it Possible? in SAS Visual Analytics https://communities.sas.com/t5/SAS-Visual-Analytics/Draw-Graph-from-Selection-of-Word-Is-it-Possible/m-p/187182#M1328 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>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.</P><P></P><P>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.</P><P></P><P>It would be helpful to explore location wise business if this option exists.</P><P></P><P>- satlr</P></BODY></HTML> Mon, 21 Apr 2014 09:29:09 GMT sat_lr 2014-04-21T09:29:09Z Draw Graph from Selection of Word - Is it Possible? https://communities.sas.com/t5/SAS-Visual-Analytics/Draw-Graph-from-Selection-of-Word-Is-it-Possible/m-p/187182#M1328 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>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.</P><P></P><P>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.</P><P></P><P>It would be helpful to explore location wise business if this option exists.</P><P></P><P>- satlr</P></BODY></HTML> Mon, 21 Apr 2014 09:29:09 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Draw-Graph-from-Selection-of-Word-Is-it-Possible/m-p/187182#M1328 sat_lr 2014-04-21T09:29:09Z Re: Draw Graph from Selection of Word - Is it Possible? https://communities.sas.com/t5/SAS-Visual-Analytics/Draw-Graph-from-Selection-of-Word-Is-it-Possible/m-p/187183#M1329 <HTML><HEAD></HEAD><BODY><P>There are a number of ways (functions) that you can search a text string for a sub-string or word using SAS.</P><P></P><P>The <A href="http://support.sas.com/documentation/cdl/en/lefunctionsref/67239/HTML/default/viewer.htm#p16rdsa30vmm43n1ej4936nwa01t.htm">FINDW</A> function seems a likely candidate.</P></BODY></HTML> Mon, 21 Apr 2014 10:52:08 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Draw-Graph-from-Selection-of-Word-Is-it-Possible/m-p/187183#M1329 data_null__ 2014-04-21T10:52:08Z Re: Draw Graph from Selection of Word - Is it Possible? https://communities.sas.com/t5/SAS-Visual-Analytics/Draw-Graph-from-Selection-of-Word-Is-it-Possible/m-p/187184#M1330 <HTML><HEAD></HEAD><BODY><P>thanks very much. let me try it out.</P><P></P><P>satlr</P></BODY></HTML> Tue, 22 Apr 2014 13:23:55 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Draw-Graph-from-Selection-of-Word-Is-it-Possible/m-p/187184#M1330 sat_lr 2014-04-22T13:23:55Z