Hello,
I would like help finding the max value for each meter. My data is below.
Meter date hr1 hr2 hr3 hr4 hr5
123 1/1/2015 2 15 6 7 13
234 1/1/2015 40 10 3 1 0
345 1/1/2015 12 15 6 24 12
456 1/1/2015 2 18 5 6 11
567 1/1/2015 2 10 33 1 21
And I want it to look like...
Meter date MaxVal
123 1/1/2015 15
234 1/1/2015 40
345 1/1/2015 24
456 1/1/2015 18
567 1/1/2015 33
Using Query Builder
Select the two fields you want
Create a Calculated Column
Define it as Max(hr1, hr2, hr3, hr4, hr5)
data want;
set have;
MaxVal=max(of hr:);
run;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.