topic Re: Dot plot with multiple measures in SAS Visual Analytics

Dot plot with multiple measures

smm662002 — Fri, 28 Oct 2022 17:11:45 GMT

Hello,

SAS VIYA 3.5

SAS Visual Analytics 8.5

Can anyone advise if it would be possible to have a dot plot with multiple measures? Or to create custom chart?

I would like to create a plot similar to the one attached.

Thank you,

smm662002

Re: Dot plot with multiple measures

ballardw — Fri, 28 Oct 2022 20:12:53 GMT

From what you see a data set with 3 variables should be able to replicate that. Two variables are the x and y axis variables. The third would indicate which "group" would be used to identify and set properties like marker type, color and size.

If by different "measures" you mean different variables holding one of the values then you modify the data to have a generic "value" variable, pick your name, and then add the group variable base on which variable supplied that value.

I don't use VA so won't try to provide an example but once you have data that looks like that it should be relatively easy.

An example would be the SASHELP.Class data set. Think of the X axis as Height, Y axis as Weight and Sex or Age as group variable.

Re: Dot plot with multiple measures

Madelyn_SAS — Fri, 28 Oct 2022 20:42:53 GMT

Did you try placing one scatter plot on top of the other using the Graph Builder? You can have a Y axis for each plot.

Re: Dot plot with multiple measures

smm662002 — Fri, 28 Oct 2022 21:14:51 GMT

Hi,
Thank you for your answer.
Unfortunateley scatter plot only uses measures for both x and y axes, and in my scenario x axis is a category.
And dot plot are not available in "Create custom charts" so I can't superpose two dot plot. Also, I tried to customize existing dot plot by trying to add a "group" variable but "group" is not available either.

Re: Dot plot with multiple measures

smm662002 — Fri, 28 Oct 2022 21:19:11 GMT

Hi,

Thank you for your answer. The example provided was created in SAS using proc gplot.
The question was how to create the same output using Visual Analytics default or custum objects (without usin web-content or DDC objects)

Thank you,
Smm662002

Re: Dot plot with multiple measures

BrunoMueller — Thu, 10 Nov 2022 10:45:09 GMT

Use the custom graph builder

Add a line plot
In the options for the line plot, check to have markers, then deselect line
add a group role

This should give you what your are after.

As an alternative you can overlay another line chart on the existing one, apply the same changes (this time no group), change the marker symbol for the second line chart to something else

BTW in the graph builder you can change the x axis for a scatter plot to be a category. But be aware a scatter plot will not do any aggregation of the data, it will plot all datapoints.

Re: Dot plot with multiple measures

acordes — Thu, 10 Nov 2022 11:33:31 GMT

@smm662002 you won't get a better proposal than @BrunoMueller has suggested.

Re: Dot plot with multiple measures

smm662002 — Thu, 10 Nov 2022 12:57:16 GMT

Hi,
Thank you.
Great solution.
Regards,
Smm662002