topic Re: Customizing Scatterplots with SGPLOT in Graphics Programming

Customizing Scatterplots with SGPLOT

OPHD1 — Fri, 03 Jan 2014 20:03:05 GMT

Hi,

I am looking to customize a scatterplot produced with SGPLOT in the following ways:

1. Highlight specific data points

A. Highlight one data point in one color

B. Highlight a group of data points (not criteria A) in a second color

C. Highlight the other points that do not meet criteria A and B in a third color

2. Superimpose two lines -

A. One at a given point on the y axis

B. One at a given point on the x axis.

Sample data is attached.

1A. Pick one id, for example, AB212, and fill the point one color (e.g. blue)

1B. Since AB212 is a part of group 1, fill all data points in group 1 a second color (e.g. purple)

1C. Every other data point (groups in (2, 3)) , fill a third color (e.g. green)

2A. Create a black line (thin) across the xaxis for the xline value

2B. Create a black line (thin) across the yaxis for the yline value.

Re: Customizing Scatterplots with SGPLOT

DanH_sas — Fri, 03 Jan 2014 20:43:01 GMT

What version of SAS do you have?

Re: Customizing Scatterplots with SGPLOT

OPHD1 — Fri, 03 Jan 2014 20:44:54 GMT

Hi Dan, 9.3

Re: Customizing Scatterplots with SGPLOT

DanH_sas — Fri, 03 Jan 2014 21:31:12 GMT

Add the following code to your sample data. Simply change the SELECT_ID macro variable to the ID of interest, and the code will take care of the rest. Let me know if you have any questions about it.

Thanks!
Dan

/*-----------------------------------------------------------------------------------------------------------------*/

%let select_id=AB212;

/* Find the group of interest */

data _null_;

set test;

if (id eq &select_id) then call symput('ACTIVEGROUP', group);

run;

data plotdata;

length grpstr $ 15;

label grpstr="ID";

set test;

ref_x = .;

ref_y = .;

if (id eq "&select_id") then do;

grpstr="&select_id";

ref_x = x;

ref_y = y;

end;

else if (group eq symget('ACTIVEGROUP')) then grpstr="In same group";

else grpstr="In other groups";

run;

data attrmap;

retain id "grpmap" markersymbol "circlefilled";

input value $ 1-15 markercolor $ 16-22;

cards;

In other groups green

In same group purple

_other_ blue

;

run;

proc sgplot data=plotdata dattrmap=attrmap;

scatter x=x y=y / group=grpstr attrid=grpmap;

refline ref_x / axis=x label;

refline ref_y / label;

run;

Re: Customizing Scatterplots with SGPLOT

OPHD1 — Mon, 06 Jan 2014 14:06:09 GMT

Thank you so much Dan. I made a few changes and this works perfectly for what I was looking for. I really appreciate it.