topic Re: Binning & Scatter plot in SAS Programming

Binning & Scatter plot

acegsm — Sat, 16 Jan 2016 20:00:50 GMT

Good afternoon; I have a massive file and currrently I have scatter plots where the x-axis represents time1 and the y-axis represents time2. However, if possible, I would like to somehow reflect the amount of data reflected in each of those points (e.g. change the size of the point to reflect the bin size). Any suggestions on how I would accomplish this task? Thank you!

Re: Binning & Scatter plot

acegsm — Sat, 16 Jan 2016 20:02:27 GMT

Oh! I should note that I am using sgplot!

Re: Binning & Scatter plot

PGStats — Sat, 16 Jan 2016 21:19:10 GMT

Use a bubble plot!

Re: Binning & Scatter plot

acegsm — Sat, 16 Jan 2016 21:37:18 GMT

I was just looking at those! Can you use them with sgplot in SAS 9.2; I just found a powerpoint that it is a new SGplot (http://www.sc-ctsi.org/assets/news-images/SAS93_SGProcedure_Static.pdf).

Re: Binning & Scatter plot

Reeza — Sun, 17 Jan 2016 03:42:33 GMT

We didn't/couldn't know you were using SAS 9.2...

GPLOT supports a bubble plot in SAS 9.2

Re: Binning & Scatter plot

Rick_SAS — Tue, 19 Jan 2016 13:17:48 GMT

When you say you have "a massive file," I assume that means that you do not have a single variable that summarizes the amount of data for each combination of time point. I think you need to perform 2-D binning of the data first, and then visualize the binned data.

Since SAS 9.2 is now 8 years old, and there have been 7 releases of SAS since then, it is hard to remember what techniques were available back then. For example, if you were using a modern version of SAS, I would recommend that you construct a hexagonal bin plot. Since that won't work in SAS 9.2, I suggest you look into using PROC KDE to count observations in two-dimensional bins.