topic Re: How to find Max observation? in SAS Enterprise Guide https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-find-Max-observation/m-p/201922#M15179 <HTML><HEAD></HEAD><BODY><P>Using Query Builder</P><P>Select the two fields you want</P><P>Create a Calculated Column</P><P>Define it as&nbsp; Max(hr1, hr2, hr3, hr4, hr5)</P></BODY></HTML> Tue, 18 Aug 2015 19:58:49 GMT Reeza 2015-08-18T19:58:49Z How to find Max observation? https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-find-Max-observation/m-p/201921#M15178 <HTML><HEAD></HEAD><BODY><P> <BR />Hello,</P><P></P><P>I would like help finding the max value for each meter. My data is below.</P><P></P><P>Meter&nbsp;&nbsp;&nbsp;&nbsp; date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; hr1&nbsp;&nbsp;&nbsp;&nbsp; hr2&nbsp;&nbsp;&nbsp;&nbsp; hr3&nbsp;&nbsp;&nbsp;&nbsp; hr4&nbsp;&nbsp;&nbsp;&nbsp; hr5</P><P>123&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1/1/2015&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13</P><P>234&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1/1/2015&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 40&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>345&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1/1/2015&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15&nbsp;&nbsp;&nbsp;&nbsp; 6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 24&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12</P><P>456&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1/1/2015&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 18&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11</P><P>567&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1/1/2015&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 33&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 21</P><P></P><P>And I want it to look like...</P><P></P><P>Meter&nbsp;&nbsp;&nbsp;&nbsp; date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MaxVal</P><P>123&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1/1/2015&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15</P><P>234&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1/1/2015&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 40&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>345&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1/1/2015&nbsp;&nbsp;&nbsp;&nbsp; 24&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>456&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1/1/2015&nbsp;&nbsp;&nbsp;&nbsp; 18&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>567&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1/1/2015&nbsp;&nbsp;&nbsp;&nbsp; 33</P></BODY></HTML> Tue, 18 Aug 2015 19:40:03 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-find-Max-observation/m-p/201921#M15178 wil1212 2015-08-18T19:40:03Z Re: How to find Max observation? https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-find-Max-observation/m-p/201922#M15179 <HTML><HEAD></HEAD><BODY><P>Using Query Builder</P><P>Select the two fields you want</P><P>Create a Calculated Column</P><P>Define it as&nbsp; Max(hr1, hr2, hr3, hr4, hr5)</P></BODY></HTML> Tue, 18 Aug 2015 19:58:49 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-find-Max-observation/m-p/201922#M15179 Reeza 2015-08-18T19:58:49Z Re: How to find Max observation? https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-find-Max-observation/m-p/201923#M15180 <HTML><HEAD></HEAD><BODY><P>data want;</P><P>&nbsp;&nbsp;&nbsp; set have;</P><P>&nbsp;&nbsp;&nbsp; MaxVal=max(of hr:);</P><P>run;<img id="smileywink" class="emoticon emoticon-smileywink" src="https://communities.sas.com/i/smilies/16x16_smiley-wink.png" alt="Smiley Wink" title="Smiley Wink" /></P></BODY></HTML> Tue, 18 Aug 2015 20:02:50 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-find-Max-observation/m-p/201923#M15180 slchen 2015-08-18T20:02:50Z