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
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
Thank you!!!!!!!!
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!
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.