Filter Top 4 Values from Dataset for Plot

[tburus]

I am making a number of visualizations using an injury dataset. I have 11 injury sites, but only want to include the Top 4 in my visualizations. The Top 4 will vary depending on sport and scenario (i.e. practice, game, etc.). Is there a way to automate code to filter these out using some sort of sorting or ranking operation? I will primarily be using PROC SGPLOT, but may also use PROC SGRENDER and PROC GCHART to create the visualizations. A sample of one such visualization code is below:

proc sgplot data=body_pct;
	format pct mypct.;
	styleattrs datacolors=("&Dblue" "&DGray" "&Dblack" "&Dtan");
	vbar injsite / response=pct datalabel datalabelfitpolicy=none datalabelattrs=(size=6) nooutline;
	xaxis label="Injury Site";
run;

[Kurt_Bremser · Accepted solution]

Look at the RANK Procedure, and use a where condition on the created ranks.

[tburus]

Thanks. That worked perfectly.