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

[DreLo]

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

[FredrikE]

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

[Sam_SAS]

Hello DreLo,

What version of VA do you have?

Thanks,

Sam

[DreLo]

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

[Sam_SAS]

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=p061hi0pikj...

[DreLo]

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

[Sam_SAS · Accepted solution]

Glad to hear it! Thanks for following up here 🙂