Filter Top 4 Values from Dataset for Plot

tburus — Thu, 11 Jun 2020 05:04:08 GMT

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;

Re: Filter Top 4 Values from Dataset for Plot

Kurt_Bremser — Thu, 11 Jun 2020 05:21:20 GMT

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

Re: Filter Top 4 Values from Dataset for Plot

tburus — Thu, 11 Jun 2020 05:53:14 GMT

Thanks. That worked perfectly.

topic Filter Top 4 Values from Dataset for Plot in SAS Programming

Filter Top 4 Values from Dataset for Plot

Re: Filter Top 4 Values from Dataset for Plot

Re: Filter Top 4 Values from Dataset for Plot