topic Re: Create scatter plot with quadrants in Graphics Programming

Create scatter plot with quadrants

Sean_OConnor — Mon, 29 May 2017 15:01:29 GMT

Folks,

I would like to create a visual aid for my data in order to help me understand outliers.

What I would like to do is compare values obtained from a survey with values from other sources to see if there is a mismatch and where.

I was thinking of creating a scatter plot and divding it into four sectors.

My X-axis would be survey values and Y would be Other values.

Therefore the top left would be low survey value high other value, top right high survey value, high admin value and so on.

I've seen such an example for proc gplot bubble graph but I can't seem to replicate it for a scatter graph. Could anyone provide some assitance please?

Here is some sample data for people to look at.

data sample;                                                                                                                          
   input id $ 2. survey other;                                                                                                 
   datalines;                                                                                                                           
01     15000 65000                                                                                                        
02 6500     6500                                                                                                       
03   8426 10000                                                                                                      
04      1650   16805                                                                                                       
05 630               1500                                                                                         
06  110055           56812                                                                                            
07     24568           15200                                                                                             
08   6000  7800                                                                                                        
;                                                                                                                                       
run;

Re: Create scatter plot with quadrants

Rick_SAS — Mon, 29 May 2017 20:13:05 GMT

You don't mention how you intend to determine the cutoff values, but if you are looking at a regression context, you can look at the ROBUSTREG procedure, which automatically detects points of high-leverage and outliers. See the doc for the robust distance plot, which you can create as follows:

proc robustreg data=sample method=MM plots(only)=rdplot;
model other =survey;
run;

If you have your own method, you can use the REFLINE statement to add vertical and horizontal lines to your scatter plot:

proc sgplot data=sample;
scatter x=survey y=other;
refline 22400 / axis=x;
refline 20000 / axis=y;
run;

Re: Create scatter plot with quadrants

Sean_OConnor — Tue, 30 May 2017 09:52:43 GMT

Rick when I try to run the following command I get the following error.

ods graphics on;
22         proc robustreg data=varsofimport method=MM plots(only)=rdplot;
ERROR: Library COMMON does not exist.
ERROR: Library COMMON does not exist.
WARNING: Unable to load prototypes from 'common.funcs'.
23         model nat_totinc =nat_totinc_admin;
24         run;

Re: Create scatter plot with quadrants

Rick_SAS — Tue, 30 May 2017 10:26:46 GMT

1. What version of SAS?

2. What SAS interface? (Enterprise Guide? SAS Studio? SAS University Edition?)

3. Can you run the Getting Started example in the ROBUSTREG documentation?