DATA Step, Macro, Functions and more

Binning & Scatter plot

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 16
Accepted Solution

Binning & Scatter plot

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!


Accepted Solutions
Solution
‎01-16-2016 11:15 PM
Respected Advisor
Posts: 4,925

Re: Binning & Scatter plot

Use a bubble plot!

PG

View solution in original post


All Replies
Occasional Contributor
Posts: 16

Re: Binning & Scatter plot

Oh! I should note that I am using sgplot!
Solution
‎01-16-2016 11:15 PM
Respected Advisor
Posts: 4,925

Re: Binning & Scatter plot

Use a bubble plot!

PG
Occasional Contributor
Posts: 16

Re: Binning & Scatter plot

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).

Super User
Posts: 19,815

Re: Binning & Scatter plot

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

 

GPLOT supports a bubble plot in SAS 9.2

SAS Super FREQ
Posts: 3,753

Re: Binning & Scatter plot

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.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 5 replies
  • 353 views
  • 2 likes
  • 4 in conversation