topic i need a min or max value in the same variable for each id without proc sql can anyone help in SAS Certification https://communities.sas.com/t5/SAS-Certification/i-need-a-min-or-max-value-in-the-same-variable-for-each-id/m-p/845338#M1407 <P>id&nbsp; &nbsp; wt&nbsp; &nbsp; &nbsp; hr</P><P>1&nbsp; &nbsp; 56&nbsp; &nbsp; &nbsp; &nbsp;89</P><P>1&nbsp; &nbsp; &nbsp;50&nbsp; &nbsp; &nbsp; 84</P><P>1&nbsp; &nbsp; &nbsp;51&nbsp; &nbsp; &nbsp; &nbsp;98</P><P>2&nbsp; &nbsp; &nbsp;51&nbsp; &nbsp; &nbsp; &nbsp;86</P><P>2&nbsp; &nbsp; &nbsp; 58&nbsp; &nbsp; &nbsp; 89</P><P>2&nbsp; &nbsp; &nbsp;50&nbsp; &nbsp; &nbsp; &nbsp;105</P> Sun, 20 Nov 2022 14:30:05 GMT rogeralfa111 2022-11-20T14:30:05Z i need a min or max value in the same variable for each id without proc sql can anyone help https://communities.sas.com/t5/SAS-Certification/i-need-a-min-or-max-value-in-the-same-variable-for-each-id/m-p/845338#M1407 <P>id&nbsp; &nbsp; wt&nbsp; &nbsp; &nbsp; hr</P><P>1&nbsp; &nbsp; 56&nbsp; &nbsp; &nbsp; &nbsp;89</P><P>1&nbsp; &nbsp; &nbsp;50&nbsp; &nbsp; &nbsp; 84</P><P>1&nbsp; &nbsp; &nbsp;51&nbsp; &nbsp; &nbsp; &nbsp;98</P><P>2&nbsp; &nbsp; &nbsp;51&nbsp; &nbsp; &nbsp; &nbsp;86</P><P>2&nbsp; &nbsp; &nbsp; 58&nbsp; &nbsp; &nbsp; 89</P><P>2&nbsp; &nbsp; &nbsp;50&nbsp; &nbsp; &nbsp; &nbsp;105</P> Sun, 20 Nov 2022 14:30:05 GMT https://communities.sas.com/t5/SAS-Certification/i-need-a-min-or-max-value-in-the-same-variable-for-each-id/m-p/845338#M1407 rogeralfa111 2022-11-20T14:30:05Z Re: i need a min or max value in the same variable for each id without proc sql can anyone help https://communities.sas.com/t5/SAS-Certification/i-need-a-min-or-max-value-in-the-same-variable-for-each-id/m-p/845339#M1408 Sounds like homework maybe?<BR /><BR />I'll offer a hint: I'd use PROC SORT and then FIRST./LAST. processing.<BR /><BR />Have fun experimenting. Sun, 20 Nov 2022 14:38:16 GMT https://communities.sas.com/t5/SAS-Certification/i-need-a-min-or-max-value-in-the-same-variable-for-each-id/m-p/845339#M1408 Mark2010 2022-11-20T14:38:16Z Re: i need a min or max value in the same variable for each id without proc sql can anyone help https://communities.sas.com/t5/SAS-Certification/i-need-a-min-or-max-value-in-the-same-variable-for-each-id/m-p/845346#M1409 <P>What does your desired result look like? What have you tried already?</P> Sun, 20 Nov 2022 18:32:16 GMT https://communities.sas.com/t5/SAS-Certification/i-need-a-min-or-max-value-in-the-same-variable-for-each-id/m-p/845346#M1409 PeterClemmensen 2022-11-20T18:32:16Z Re: i need a min or max value in the same variable for each id without proc sql can anyone help https://communities.sas.com/t5/SAS-Certification/i-need-a-min-or-max-value-in-the-same-variable-for-each-id/m-p/845347#M1410 <P>The&nbsp;<A href="https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/proc/p0f0fjpjeuco4gn1ri963f683mi4.htm" target="_blank" rel="noopener">MEANS Procedure</A>&nbsp;will be your tool of choice.</P> <P>Use</P> <PRE><CODE class=" language-sas">class id; var wt hr;</CODE></PRE> <P>I leave it as an exercise for you to define the statistics.</P> Sun, 20 Nov 2022 18:58:45 GMT https://communities.sas.com/t5/SAS-Certification/i-need-a-min-or-max-value-in-the-same-variable-for-each-id/m-p/845347#M1410 Kurt_Bremser 2022-11-20T18:58:45Z