Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

VA 7.3 Scatter Plot with Categorical Axis

Posts: 1,471

VA 7.3 Scatter Plot with Categorical Axis

Using VA 7.3 Report Designer, I'm trying to build a scatter plot that has a categorical x-axis and a continuous metric on the y-axis.  Is this possible?


SGPLot doesn't care if an axis is numeric or character.  I want the VA equivalent of:

proc sgplot data=sashelp.shoes;
  scatter x=region y=sales;



Looks like the VA scatter plot will only plot two continuous metrics.  Is there a way to put a categorical variable on the x-axis? 


All I can think is to make a numeric variable that is coded 1 through n for the n levels of my categorical variable.  And then use a custom format to label the values with 1 - n with the text from my categorical variable.  So for a above, I would make Region_N with values 1-10.  And the format would say 1="Africa" 2="Asia" etc.  But.. Ugh.



Ask a Question
Discussion stats
  • 0 replies
  • 1 in conversation