topic Re: Plots for Nested or hierarchical data in Graphics Programming

Plots for Nested or hierarchical data

SKK — Thu, 06 Dec 2018 07:12:23 GMT

I have nested data with counts for each of them and I need to plot them. After some research I found sunburst chart would be a appropriate model to chart them but couldn't find any SAS procedures for it. Is there any procedures like GMAP or GCHART to program Sunburst charts ?

Also is there any other appropriate model for plotting nested data ?

Re: Plots for Nested or hierarchical data

PaalNavestad — Thu, 06 Dec 2018 07:44:52 GMT

Hi there is an easy treemap option in SAS VA. If you do not have that available I think you'll find some treemap options in sgplot.

See in the SAS blog Graphically speaking. There are usually some very good ideas there.

Re: Plots for Nested or hierarchical data

SASKiwi — Thu, 06 Dec 2018 07:45:59 GMT

Is this the sort of chart you had in mind?

https://communities.sas.com/t5/SAS-Communities-Library/Visualizing-nested-data-with-a-sunburst-chart-in-SAS-Visual/ta-p/511114

Re: Plots for Nested or hierarchical data

SKK — Thu, 06 Dec 2018 07:49:42 GMT

Yes Exactly... But I dont have access to SAS VA.. So is there any other way to do this ?

Re: Plots for Nested or hierarchical data

PaalNavestad — Thu, 06 Dec 2018 07:53:39 GMT

You can do it with sgplot or the GTL language. I do not have an example handy.
You can alos look at proc tree from SAS/STAT that show the hierarchy very well. You have to juggle a bit.
I think I've seen an example in the graphically speaking blog. Just google graphically speaking sas and it gets you there

Re: Plots for Nested or hierarchical data

SKK — Thu, 06 Dec 2018 07:58:49 GMT

Thanks for the information I will look into that blog... Is it possible to create Sub-grouped donut chart for multiple level nested data ?

Re: Plots for Nested or hierarchical data

PaalNavestad — Thu, 06 Dec 2018 11:12:11 GMT

I do not know. I seem to remember I did create a set of pies or donuts using sgchart about 15 years ago. But I can't exactly remenber how I very seldom use pie charts anymore and for the sunflower chart I had problems seeing the use.

Have you just tried using midpoint/group and subgroup in gchart. I would prefer a treemap. There is a mosaic plot in GTL that you can try.

Re: Plots for Nested or hierarchical data

Rick_SAS — Thu, 06 Dec 2018 14:27:28 GMT

Statisticians use mosaic plots to display hierarchical data, although in practice it works best for three or fewer levels of nesting. PROC FREQ can display a mosaic plot automatically, The plot is often used to accompany an analysis/discussion of whether there is association between variables.