topic How to get Max value of a column in SAS Programming https://communities.sas.com/t5/SAS-Programming/How-to-get-Max-value-of-a-column/m-p/358335#M84172 <P><SPAN>Hello everyone,</SPAN><BR /><BR /><SPAN>I need to find the maximum value of a variable looking at all the previous values in the column. i have a dataset that looks the one listed below. i want to create a variable v4 with the maximum value of all the previous values in the column.&nbsp;</SPAN><BR /><BR /><STRONG><U>DATASET 1</U><I><BR />V1 V2 V3<BR />01 AA 02</I></STRONG></P> <P><STRONG><I>01 AA 08</I></STRONG></P> <P><STRONG><I>01 AA 03<BR />02 BB 24<BR />02 BB 98</I></STRONG></P> <P><STRONG><I>02 BB 24</I></STRONG></P> <P><STRONG><I>03 CC 11</I></STRONG></P> <P><STRONG><I>03 CC 99</I></STRONG></P> <P><STRONG><I>03 CC 15<BR />02 DD 54<BR /><BR /></I><BR /><U>DATASET 2</U><I><BR />V1 V2 V3 v4&nbsp;<BR /></I></STRONG></P> <P>&nbsp;</P> <P><STRONG><I>01 AA 02 02</I></STRONG></P> <P><STRONG><I>01 AA 08 08</I></STRONG></P> <P><STRONG><I>01 AA 03 08<BR />02 BB 24 24<BR />02 BB 98 98</I></STRONG></P> <P><STRONG><I>02 BB 24 98</I></STRONG></P> <P><STRONG><I>03 CC 11 98</I></STRONG></P> <P><STRONG><I>03 CC 99 99</I></STRONG></P> <P><STRONG><I>03 CC 15 99<BR />02 DD 54 99</I></STRONG></P> <P><STRONG><I>&nbsp;</I></STRONG></P> Fri, 12 May 2017 19:42:11 GMT zqkal 2017-05-12T19:42:11Z How to get Max value of a column https://communities.sas.com/t5/SAS-Programming/How-to-get-Max-value-of-a-column/m-p/358335#M84172 <P><SPAN>Hello everyone,</SPAN><BR /><BR /><SPAN>I need to find the maximum value of a variable looking at all the previous values in the column. i have a dataset that looks the one listed below. i want to create a variable v4 with the maximum value of all the previous values in the column.&nbsp;</SPAN><BR /><BR /><STRONG><U>DATASET 1</U><I><BR />V1 V2 V3<BR />01 AA 02</I></STRONG></P> <P><STRONG><I>01 AA 08</I></STRONG></P> <P><STRONG><I>01 AA 03<BR />02 BB 24<BR />02 BB 98</I></STRONG></P> <P><STRONG><I>02 BB 24</I></STRONG></P> <P><STRONG><I>03 CC 11</I></STRONG></P> <P><STRONG><I>03 CC 99</I></STRONG></P> <P><STRONG><I>03 CC 15<BR />02 DD 54<BR /><BR /></I><BR /><U>DATASET 2</U><I><BR />V1 V2 V3 v4&nbsp;<BR /></I></STRONG></P> <P>&nbsp;</P> <P><STRONG><I>01 AA 02 02</I></STRONG></P> <P><STRONG><I>01 AA 08 08</I></STRONG></P> <P><STRONG><I>01 AA 03 08<BR />02 BB 24 24<BR />02 BB 98 98</I></STRONG></P> <P><STRONG><I>02 BB 24 98</I></STRONG></P> <P><STRONG><I>03 CC 11 98</I></STRONG></P> <P><STRONG><I>03 CC 99 99</I></STRONG></P> <P><STRONG><I>03 CC 15 99<BR />02 DD 54 99</I></STRONG></P> <P><STRONG><I>&nbsp;</I></STRONG></P> Fri, 12 May 2017 19:42:11 GMT https://communities.sas.com/t5/SAS-Programming/How-to-get-Max-value-of-a-column/m-p/358335#M84172 zqkal 2017-05-12T19:42:11Z Re: How to get Max value of a column https://communities.sas.com/t5/SAS-Programming/How-to-get-Max-value-of-a-column/m-p/358338#M84174 <PRE>data DATASET1; input (V1 V2 V3) ($); cards; 01 AA 02 01 AA 08 01 AA 03 02 BB 24 02 BB 98 02 BB 24 03 CC 11 03 CC 99 03 CC 15 02 DD 54 ; data dataset2; set dataset1; retain v4; v4=max(v3,v4); run; </PRE> <P>Art, CEO, AnalystFinder.com</P> <P>&nbsp;</P> Fri, 12 May 2017 19:49:01 GMT https://communities.sas.com/t5/SAS-Programming/How-to-get-Max-value-of-a-column/m-p/358338#M84174 art297 2017-05-12T19:49:01Z