DATA Step, Macro, Functions and more

Complex Where Clause, Cutting Off At An Angle

Reply
Regular Contributor
Posts: 223

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: 19,770

Re: Complex Where Clause, Cutting Off At An Angle

Posted in reply to NicholasKormanik

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: 10,020

Re: Complex Where Clause, Cutting Off At An Angle

Posted in reply to NicholasKormanik
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: 10,020

Re: Complex Where Clause, Cutting Off At An Angle

Posted in reply to NicholasKormanik

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
  • 221 views
  • 0 likes
  • 3 in conversation