topic Re: Resizing xaxis in sgplot in Graphics Programming

Resizing xaxis in sgplot

sarahsasuser — Sun, 16 Nov 2014 14:42:13 GMT

I have a plot where a lot of the data is clustered around the 0 to 250 values on xaxis. It's difficult to see how many datapoints there are and so I'd like to expand the x-axis. However, the max value for the x-axis is over 2000 and there are not many datapoints in between 1000 and 2000. Therefore making the plot wider also increases the dead space. Is there any way to zoom in on the lower end of the x-axis and then truncate the the middle of the plot? Ideally, I'd like to show 0 to 500 by 50 and then 500 to 2000 by 500.

Thanks!

Sarah

Re: Resizing xaxis in sgplot

djrisks — Sun, 16 Nov 2014 15:19:02 GMT

Sarah, a few options might be to log the x-axis if there are no 0 values, or to use Broken axis. I don't know what version of SAS you have but I'm sure one of these links will help you to utilise broken axis techniques:

Broken Y-Axis - Graphically Speaking

Broken Axis - Graphically Speaking

Thanks,

Kriss

Re: Resizing xaxis in sgplot

sarahsasuser — Sun, 16 Nov 2014 15:32:31 GMT

Thanks. Is there a way to limit the broken piece to just the x-axis like in the image on the right below?

Another option might be to increase the dot/bubble size according to the frequency. I have a number of the same values and increasing the size of the dot would be a good way to show the data. I have searched for this on the forum using the term bubble, but those articles usually apply to a third variable, not the frequency. Do you have any advice on that?

Thanks

Re: Resizing xaxis in sgplot

Jay54 — Sun, 16 Nov 2014 17:35:39 GMT

For now, the options for you will be to use one of the following:

- Use the broken axis as is now, but erase the full break indicator using DRAW or Annotate.

- Use the panel idea to break (Broken Y-Axis) using GTL,and turn off the cell borders and axis lines.

- I have seen users add a break symbol like you want using draw or annotate.

To set size by frequency, generally we use a third variable for sizing. You can use the BUBBLE plot or SCATTER with MarkerSizeResponse=variable option. You will have to process your data to only keep unique (x,y) values with frequency counts. See blog article on Bivariate Response. You make a good suggestion to automatically size by frequency when the (x, y) values are identical. We will see if it is feasible to add.

Finally, we have heard from many users including yourself that often a simple axis break may be preferred. So, while this does not help you now, I am happy to say this is now included for the next release as shown here. Multiple break symbols are supported including the ones you have shown. Break is only shown if there is an axis or frame to break. Yes, the data is made up to test the feature, with values of height > 470.

Re: Resizing xaxis in sgplot

sarahsasuser — Mon, 17 Nov 2014 04:16:03 GMT

Thanks Sanjay, these are great options!

Re: Resizing xaxis in sgplot

Jay54 — Wed, 19 Nov 2014 19:24:33 GMT

To see what you can do now, see: Axis Break Appearance Macro - Graphically Speaking

Re: Resizing xaxis in sgplot

sarahsasuser — Thu, 20 Nov 2014 19:53:20 GMT

Hi Sanjay,

Thank you for these tips. With the MarkerSizeResponse=variable option, I'm unsure of how to use that. I created a frequency variable called count and added it to my program:

proc sgplot data=freqs noautolegend;

scatter x= VAR1 y=VAR2/group=VAR3 MarkerSizeResponse=count markerattrs=(size=9);

xaxis label....

run;

Thanks,

Sarah

Re: Resizing xaxis in sgplot

sarahsasuser — Thu, 20 Nov 2014 20:27:01 GMT

Sorry I see now that I need to use proc template. I've never used that proc, but I got the markersizeresponse option to work with it. I'm just having trouble keeping the group variable intact so that the circles will be two different colors depending on the group.

Thanks!

Sarah

Re: Resizing xaxis in sgplot

Jay54 — Thu, 20 Nov 2014 20:51:02 GMT

Looks like we left that off the SGPLOT scatter statement due to advent of Bubble.:

proc sgplot data=sashelp.class;

bubble x=height y=weight size=age;

run;

If you must have scatter, then use GTL.,

proc template;

define statgraph markerSize;

begingraph / datasymbols=(circlefilled squarefilled);

entrytitle 'Weight by Height by Age for all Students';

layout overlay;

scatterplot x=height y=weight / markersizeresponse=age group=sex name='a' filledoutlinedmarkers=true;

discretelegend 'a';

endlayout;

endgraph;

end;

run;

proc sgrender data=sashelp.class template=markerSize;

run;