topic Re: Complex Where Clause, Cutting Off At An Angle in SAS Programming

Complex Where Clause, Cutting Off At An Angle

NKormanik — Sat, 23 Jul 2016 23:41:49 GMT

What might be the best way to cut out all observations left of a particular line on a scatter plot.

I do not know the equation for the line.

Line on scatterplot

Re: Complex Where Clause, Cutting Off At An Angle

Reeza — Sun, 24 Jul 2016 01:47:27 GMT

Find the equation of the line, you only need two points.

Recreate your graph with grid lines at a finer interal to help you find the equation.

Re: Complex Where Clause, Cutting Off At An Angle

Ksharp — Sun, 24 Jul 2016 02:21:37 GMT

You need to calculate that line's start point and slope on your own.
Calculated X and Y 's 90 percentile Maybe.




proc sgplot data=sashelp.class;
scatter x=weight y=height/ datalabel=name;
lineparm x=120 y=0 slope=-1 / lineattrs=graphdata2(thickness=4);
run;

Re: Complex Where Clause, Cutting Off At An Angle

Ksharp — Sun, 24 Jul 2016 02:52:40 GMT


data class;
 set sashelp.class;
run;
proc summary data=class;
var weight height;
output out=per(drop=_:) p90=p_weight p_height;
run;
data temp;
 set per;
 slope=-p_height/p_weight;
run;
data want;
 set class temp;
run;

proc sgplot data=want;
scatter x=weight y=height/ datalabel=name;
lineparm x=p_weight y=p_height slope=slope / lineattrs=graphdata2(thickness=4);
run;