## Complex Where Clause, Cutting Off At An Angle

Regular Contributor
Posts: 238

# 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

Super User
Posts: 23,661

## 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,761

## 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,761

## 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;

```
Discussion stats
• 3 replies
• 274 views
• 0 likes
• 3 in conversation