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!!!!!!!!

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 612 views
  • 0 likes
  • 2 in conversation