BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
mmea
Quartz | Level 8

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

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Kurt_Bremser
Super User

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.

View solution in original post

2 REPLIES 2
Kurt_Bremser
Super User

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.

mmea
Quartz | Level 8

Thank you!!!!!!!!