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!!!!!!!!
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.Register now and lock in 2025 pricing—just $495!
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.