topic Re: Wordcloud - Its treating the cell values as a string instead of individual words in SAS Visual Analytics

Wordcloud - Its treating the cell values as a string instead of individual words

DreLo — Fri, 22 Feb 2019 19:13:03 GMT

Good afternoon

i have a dataset in record layout format. Each record contains a text response (Response) from a client along with other variables to describe the client (name, stakeholder_type, location, language... - see attachment for sample data). I'm trying to prepare a word cloud to show the prevalence of the words from the Response variable however its treating the response as a string (see image below). Is there an easy way for the software to treat the words within a variable instead of the entire variable as a string.

Thank you

Re: Wordcloud - Its treating the cell values as a string instead of individual words

FredrikE — Sat, 23 Feb 2019 15:45:07 GMT

I think it should be possible, maybe this can guide you:

https://www.sas.com/content/dam/SAS/support/en/sas-global-forum-proceedings/2018/1687-2018.pdf

//Fredrk

Re: Wordcloud - Its treating the cell values as a string instead of individual words

Sam_SAS — Mon, 25 Feb 2019 16:19:56 GMT

Hello DreLo,

What version of VA do you have?

Thanks,

Sam

Re: Wordcloud - Its treating the cell values as a string instead of individual words

DreLo — Mon, 25 Feb 2019 16:24:47 GMT

Hi Sam

I'm using the SAS Viya Trial. We have purchased the VIya cloud-based software but we don't have access yet so we are using the trial.

Thank you

Re: Wordcloud - Its treating the cell values as a string instead of individual words

Sam_SAS — Mon, 25 Feb 2019 17:58:50 GMT

Have you tried using the Text Topics object? Text Topics analyzes individual words (or sometimes phrases), although it also does some grouping into topics.

To use Text Topics, you need to have a column in your table that uniquely identifies each row. It should be fairly simple to create one in your data preparation if you don't have one.

Here is the doc for Text Topics:

https://go.documentation.sas.com/?cdcId=vacdc&cdcVersion=8.3&docsetId=vaobj&docsetTarget=p061hi0pikj1dxn1gpxo1op60fc6.htm&locale=en

Re: Wordcloud - Its treating the cell values as a string instead of individual words

DreLo — Thu, 28 Feb 2019 19:35:22 GMT

Thank you Sam. This gave me exactly what I was looking for and more. Its very convenient to have the topics and the word cloud available in that view rather than building this in the Build Model section.
Cheers

Re: Wordcloud - Its treating the cell values as a string instead of individual words

Sam_SAS — Thu, 28 Feb 2019 19:46:07 GMT

Glad to hear it! Thanks for following up here 🙂