topic Re: Scatterplots in SAS Programming

Scatterplots

TheJax — Mon, 09 Nov 2020 20:04:03 GMT

Hello,

I am working with Scatterplots and have been asked to provide some additional information to a colleague.

She wants to know if there is a way to create a table of the point counts in the grid cells. For example:

I've only recently started using SAS and have no idea how to get this done. Appreciate any feedback! Thank you

Re: Scatterplots

PaigeMiller — Mon, 09 Nov 2020 20:34:26 GMT

Forget SAS for a minute. Before anyone can do SAS, we need to understand the problem.

Describe what a scatterplot of such data would look like — draw it on paper and scan it in; or find such a scatterplot on the Internet and give us the link,

AND explain how you create a scatterplot from such data DO NOT SKIP THIS PART.

Re: Scatterplots

ballardw — Mon, 09 Nov 2020 20:34:59 GMT

Are your X and Y variables used in the scatterplot actually continuous or perhaps integer? If the values are integer then likely very easy but if you they are not then you need to provide something that would let use know the boundaries of the values for each cell.

If the values are integer then perhaps:

proc tabulate data=yourdataset;
   class xvar;
   class yvar /order=descending;
   tables yvar,
             xvar*n=' '
            /misstext='0'
  ;
run;

But likely you need to do something to provide us the cell boundaries and something like above but with Custom formats would create the cell boundaries.

Re: Scatterplots

TheJax — Mon, 09 Nov 2020 20:48:59 GMT

Thank you!