BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
smm662002
Quartz | Level 8

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

1 ACCEPTED SOLUTION

Accepted Solutions
BrunoMueller
SAS Super FREQ

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.

 

 

View solution in original post

7 REPLIES 7
ballardw
Super User

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.

smm662002
Quartz | Level 8
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
Madelyn_SAS
SAS Super FREQ

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. 

smm662002
Quartz | Level 8
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.
BrunoMueller
SAS Super FREQ

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.

 

 

acordes
Rhodochrosite | Level 12

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

smm662002
Quartz | Level 8
Hi,
Thank you.
Great solution.
Regards,
Smm662002

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 7 replies
  • 956 views
  • 3 likes
  • 5 in conversation