DATA Step, Macro, Functions and more

Complex Where Clause, Cutting Off At An Angle

Reply
Regular Contributor
Posts: 212

Complex Where Clause, Cutting Off At An Angle

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

 


line.png
Super User
Posts: 17,819

Re: Complex Where Clause, Cutting Off At An Angle

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. 

 

 

Super User
Posts: 9,676

Re: Complex Where Clause, Cutting Off At An Angle

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;

Super User
Posts: 9,676

Re: Complex Where Clause, Cutting Off At An Angle


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;

Ask a Question
Discussion stats
  • 3 replies
  • 199 views
  • 0 likes
  • 3 in conversation