topic Re: Only show maximum value in proc report in New SAS User

Only show maximum value in proc report

mmea — Tue, 19 Jan 2021 09:47:06 GMT

Hi I have this proc report code


proc report data=Comp style(header) = {background = lightgray color = black } ;
	    columns region teststed metode days;
	    define Region/group;
	    define PLACE/group;
		define METHHOD/group;
		define days/group;
       
	run;

The days for some places have multiple values under a specific method , where I only want the last value in that method

Re: Only show maximum value in proc report

Kurt_Bremser — Tue, 19 Jan 2021 09:44:53 GMT

See this quick example for getting the max value for a group:

proc report data=sashelp.class;
column sex weight;
define sex / group;
define weight / analysis max;
run;

If that does not help you, please post your input dataset for PROC REPORT in a data step with datalines.

Re: Only show maximum value in proc report

mmea — Tue, 19 Jan 2021 09:46:35 GMT

Thank you!!!!!!!!