topic Re: how to compute minimum and maxium values of one variable grouped by month and year in SAS Enterprise Guide https://communities.sas.com/t5/SAS-Enterprise-Guide/how-to-compute-minimum-and-maxium-values-of-one-variable-grouped/m-p/321289#M21506 <PRE><CODE class=" language-sas">data have; input MC $ Year Month MV; yymm = mdy(month,1,year); format yymm yymon7.; drop year month; cards; US000401 2015 3 2470237.00 US000401 2015 3 2456056.00 US000401 2015 3 2455033.00 US000401 2015 4 2514014.00 US000401 2015 4 2513327.00 US000401 2015 4 2514014.00 US000401 2015 4 2493916.00 US000401 2015 4 2492461.00 US000401 2015 4 2491547.00 US000401 2015 5 2543793.00 US000401 2015 5 2543359.00 US000401 2015 5 2518758.00 US000401 2015 5 2516837.00 US000401 2015 5 2515140.00 US000401 2015 6 2564013.00 US000401 2015 6 2563221.00 US000401 2015 6 2546570.00 US000401 2015 6 2545730.00 US000401 2015 6 2544672.00 US000401 2015 7 2585750.00 US000401 2015 7 2583685.00 US000401 2015 7 2566615.00 US000401 2015 7 2565634.00 US000401 2015 7 2564660.00 US000401 2015 8 2613465.00 US000401 2015 8 2611991.00 US000401 2015 8 2588284.00 US000401 2015 8 2587931.00 US000401 2015 8 2586864.00 US000401 2015 9 2637445.00 US000401 2015 9 2636071.00 US000401 2015 9 2615970.00 US000401 2015 9 2615112.00 US000401 2015 9 2614320.00 US000401 2015 10 2669780.00 US000401 2015 10 2668465.00 US000401 2015 10 2667387.00 US000401 2015 10 2639241.00 US000401 2015 10 2638899.00 US000401 2015 10 2638631.00 US000401 2015 11 2703315.00 US000401 2015 11 2702390.00 US000401 2015 11 2674313.00 US000401 2015 11 2673004.00 US000401 2015 11 2671232.00 US000401 2015 12 2722479.00 US000401 2015 12 2721936.00 US000401 2015 12 2705452.00 US000401 2015 12 2703832.00 ;;;; run; proc print; run; proc summary data=have nway; class mc yymm; var mv; output out=stats(drop=_type_) min=min max=max; run; proc print; run; </CODE></PRE> Tue, 27 Dec 2016 13:33:54 GMT data_null__ 2016-12-27T13:33:54Z how to compute minimum and maxium values of one variable grouped by month and year https://communities.sas.com/t5/SAS-Enterprise-Guide/how-to-compute-minimum-and-maxium-values-of-one-variable-grouped/m-p/321288#M21505 <P>For the following data,</P><P>&nbsp;</P><P>How can I compute Min and Max of MV in an individual month and year?</P><P>Also I don't know how to format Year and Month so that they do appear as date type YYYY and MM.</P><P>&nbsp;</P><P>Please help.</P><P>&nbsp;</P><PRE><CODE class=" language-sas">data have; infile cards truncover expandtabs; input MC $ Year Month MV; cards; US000401 2015 3 2470237.00 US000401 2015 3 2456056.00 US000401 2015 3 2455033.00 US000401 2015 4 2514014.00 US000401 2015 4 2513327.00 US000401 2015 4 2514014.00 US000401 2015 4 2493916.00 US000401 2015 4 2492461.00 US000401 2015 4 2491547.00 US000401 2015 5 2543793.00 US000401 2015 5 2543359.00 US000401 2015 5 2518758.00 US000401 2015 5 2516837.00 US000401 2015 5 2515140.00 US000401 2015 6 2564013.00 US000401 2015 6 2563221.00 US000401 2015 6 2546570.00 US000401 2015 6 2545730.00 US000401 2015 6 2544672.00 US000401 2015 7 2585750.00 US000401 2015 7 2583685.00 US000401 2015 7 2566615.00 US000401 2015 7 2565634.00 US000401 2015 7 2564660.00 US000401 2015 8 2613465.00 US000401 2015 8 2611991.00 US000401 2015 8 2588284.00 US000401 2015 8 2587931.00 US000401 2015 8 2586864.00 US000401 2015 9 2637445.00 US000401 2015 9 2636071.00 US000401 2015 9 2615970.00 US000401 2015 9 2615112.00 US000401 2015 9 2614320.00 US000401 2015 10 2669780.00 US000401 2015 10 2668465.00 US000401 2015 10 2667387.00 US000401 2015 10 2639241.00 US000401 2015 10 2638899.00 US000401 2015 10 2638631.00 US000401 2015 11 2703315.00 US000401 2015 11 2702390.00 US000401 2015 11 2674313.00 US000401 2015 11 2673004.00 US000401 2015 11 2671232.00 US000401 2015 12 2722479.00 US000401 2015 12 2721936.00 US000401 2015 12 2705452.00 US000401 2015 12 2703832.00 ; run;</CODE></PRE><P>&nbsp;</P><P>Thanks.</P> Tue, 27 Dec 2016 13:09:51 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/how-to-compute-minimum-and-maxium-values-of-one-variable-grouped/m-p/321288#M21505 imanojkumar1 2016-12-27T13:09:51Z Re: how to compute minimum and maxium values of one variable grouped by month and year https://communities.sas.com/t5/SAS-Enterprise-Guide/how-to-compute-minimum-and-maxium-values-of-one-variable-grouped/m-p/321289#M21506 <PRE><CODE class=" language-sas">data have; input MC $ Year Month MV; yymm = mdy(month,1,year); format yymm yymon7.; drop year month; cards; US000401 2015 3 2470237.00 US000401 2015 3 2456056.00 US000401 2015 3 2455033.00 US000401 2015 4 2514014.00 US000401 2015 4 2513327.00 US000401 2015 4 2514014.00 US000401 2015 4 2493916.00 US000401 2015 4 2492461.00 US000401 2015 4 2491547.00 US000401 2015 5 2543793.00 US000401 2015 5 2543359.00 US000401 2015 5 2518758.00 US000401 2015 5 2516837.00 US000401 2015 5 2515140.00 US000401 2015 6 2564013.00 US000401 2015 6 2563221.00 US000401 2015 6 2546570.00 US000401 2015 6 2545730.00 US000401 2015 6 2544672.00 US000401 2015 7 2585750.00 US000401 2015 7 2583685.00 US000401 2015 7 2566615.00 US000401 2015 7 2565634.00 US000401 2015 7 2564660.00 US000401 2015 8 2613465.00 US000401 2015 8 2611991.00 US000401 2015 8 2588284.00 US000401 2015 8 2587931.00 US000401 2015 8 2586864.00 US000401 2015 9 2637445.00 US000401 2015 9 2636071.00 US000401 2015 9 2615970.00 US000401 2015 9 2615112.00 US000401 2015 9 2614320.00 US000401 2015 10 2669780.00 US000401 2015 10 2668465.00 US000401 2015 10 2667387.00 US000401 2015 10 2639241.00 US000401 2015 10 2638899.00 US000401 2015 10 2638631.00 US000401 2015 11 2703315.00 US000401 2015 11 2702390.00 US000401 2015 11 2674313.00 US000401 2015 11 2673004.00 US000401 2015 11 2671232.00 US000401 2015 12 2722479.00 US000401 2015 12 2721936.00 US000401 2015 12 2705452.00 US000401 2015 12 2703832.00 ;;;; run; proc print; run; proc summary data=have nway; class mc yymm; var mv; output out=stats(drop=_type_) min=min max=max; run; proc print; run; </CODE></PRE> Tue, 27 Dec 2016 13:33:54 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/how-to-compute-minimum-and-maxium-values-of-one-variable-grouped/m-p/321289#M21506 data_null__ 2016-12-27T13:33:54Z Re: how to compute minimum and maxium values of one variable grouped by month and year https://communities.sas.com/t5/SAS-Enterprise-Guide/how-to-compute-minimum-and-maxium-values-of-one-variable-grouped/m-p/321291#M21507 Just couple of modifications:<BR /><BR />YearMonth = mdy(Month,1,Year);<BR />format YearMonth monyy7.;<BR /><BR />and...<BR /><BR />proc summary data=have nway;<BR />class MC YearMonth;<BR />var MV;<BR />output out=stats(drop=_type_ _FREQ_) min=MinMV max=MaxMV;<BR />run; Tue, 27 Dec 2016 14:00:31 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/how-to-compute-minimum-and-maxium-values-of-one-variable-grouped/m-p/321291#M21507 imanojkumar1 2016-12-27T14:00:31Z Re: how to compute minimum and maxium values of one variable grouped by month and year https://communities.sas.com/t5/SAS-Enterprise-Guide/how-to-compute-minimum-and-maxium-values-of-one-variable-grouped/m-p/321298#M21508 <P>Kudos for a well-formulated question with nice example data. No miracle it got an immediate solution.</P> Tue, 27 Dec 2016 15:26:53 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/how-to-compute-minimum-and-maxium-values-of-one-variable-grouped/m-p/321298#M21508 Kurt_Bremser 2016-12-27T15:26:53Z