topic How to Sum Vertically in SAS Programming https://communities.sas.com/t5/SAS-Programming/How-to-Sum-Vertically/m-p/314528#M270824 <P>Hello All</P><P>&nbsp;</P><P>I have a table as follows</P><P>&nbsp;</P><P>ID : The ID is Unique value in the sense for a set of rows it will remains same , but the table may contain ID1, ID2,ID3,…IDn varies from case to case</P><P>Time : I have only 4 Values in the Table , Time1, Time2, Time 3 and Time4</P><P>Group : I have n different Groups starting from Grp1, Grp2, Grp3,…,Grpn from case to case</P><P>TimeDiff: Each row will be having a value and may vary from 0 to 123456789</P><P>&nbsp;</P><TABLE><TBODY><TR><TD><P><STRONG>Have</STRONG></P></TD></TR><TR><TD><P><STRONG>ID</STRONG></P></TD><TD><P><STRONG>Time</STRONG></P></TD><TD><P><STRONG>Group</STRONG></P></TD><TD><P><STRONG>TimeDiff</STRONG></P></TD></TR><TR><TD><P>ID1</P></TD><TD><P>Time1</P></TD><TD><P>Grp1</P></TD><TD><P>12371231</P></TD></TR><TR><TD><P>ID1</P></TD><TD><P>Time1</P></TD><TD><P>Grp1</P></TD><TD><P>12371231</P></TD></TR><TR><TD><P>ID1</P></TD><TD><P>Time2</P></TD><TD><P>Grp1</P></TD><TD><P>54934</P></TD></TR><TR><TD><P>ID1</P></TD><TD><P>Time2</P></TD><TD><P>Grp1</P></TD><TD><P>10543254</P></TD></TR><TR><TD><P>ID1</P></TD><TD><P>Time2</P></TD><TD><P>Grp2</P></TD><TD><P>1776401</P></TD></TR><TR><TD><P>ID1</P></TD><TD><P>Time2</P></TD><TD><P>Grp2</P></TD><TD><P>1776</P></TD></TR><TR><TD><P>ID1</P></TD><TD><P>Time3</P></TD><TD><P>Grp3</P></TD><TD><P>9</P></TD></TR><TR><TD><P>ID1</P></TD><TD><P>Time2</P></TD><TD><P>Grp3</P></TD><TD><P>522</P></TD></TR><TR><TD><P>ID1</P></TD><TD><P>Time4</P></TD><TD><P>Grp3</P></TD><TD><P>0</P></TD></TR><TR><TD><P>ID1</P></TD><TD><P>Time3</P></TD><TD><P>Grp2</P></TD><TD><P>13046</P></TD></TR><TR><TD><P>ID1</P></TD><TD><P>Time3</P></TD><TD><P>Grp1</P></TD><TD><P>167599</P></TD></TR><TR><TD><P>ID2</P></TD><TD><P>Time3</P></TD><TD><P>Grp1</P></TD><TD><P>4990</P></TD></TR><TR><TD><P>ID2</P></TD><TD><P>Time3</P></TD><TD><P>Grp3</P></TD><TD><P>0</P></TD></TR><TR><TD><P>ID2</P></TD><TD><P>Time2</P></TD><TD><P>Grp1</P></TD><TD><P>11762618</P></TD></TR><TR><TD><P>ID2</P></TD><TD><P>Time2</P></TD><TD><P>Grp3</P></TD><TD><P>0</P></TD></TR><TR><TD><P>ID2</P></TD><TD><P>Time2</P></TD><TD><P>Grp2</P></TD><TD><P>590</P></TD></TR><TR><TD><P>ID2</P></TD><TD><P>Time4</P></TD><TD><P>Grp3</P></TD><TD><P>0</P></TD></TR><TR><TD><P>ID2</P></TD><TD><P>Time3</P></TD><TD><P>Grp2</P></TD><TD><P>19738</P></TD></TR><TR><TD><P>ID2</P></TD><TD><P>Time1</P></TD><TD><P>Grp1</P></TD><TD><P>11787936</P></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I want to sum the TimeDiff if the Group having same value and Time having same value for each ID</P><P>&nbsp;</P><TABLE><TBODY><TR><TD><P><STRONG>Have</STRONG></P></TD><TD>&nbsp;</TD><TD><P><STRONG>Want</STRONG></P></TD></TR><TR><TD><P><STRONG>ID</STRONG></P></TD><TD><P><STRONG>Time</STRONG></P></TD><TD><P><STRONG>Group</STRONG></P></TD><TD><P><STRONG>TimeDiff</STRONG></P></TD><TD>&nbsp;</TD><TD><P><STRONG>ID</STRONG></P></TD><TD><P><STRONG>Time</STRONG></P></TD><TD><P><STRONG>Group</STRONG></P></TD><TD><P><STRONG>TimeDiff</STRONG></P></TD></TR><TR><TD><P>ID1</P></TD><TD><P>Time1</P></TD><TD><P>Grp1</P></TD><TD><P>12371231</P></TD><TD>&nbsp;</TD><TD><P>ID1</P></TD><TD><P>Time1</P></TD><TD><P>Grp1</P></TD><TD><P>24742462</P></TD></TR><TR><TD><P>ID1</P></TD><TD><P>Time1</P></TD><TD><P>Grp1</P></TD><TD><P>12371231</P></TD><TD>&nbsp;</TD><TD><P>ID1</P></TD><TD><P>Time2</P></TD><TD><P>Grp1</P></TD><TD><P>10598188</P></TD></TR><TR><TD><P>ID1</P></TD><TD><P>Time2</P></TD><TD><P>Grp1</P></TD><TD><P>54934</P></TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD><P>ID1</P></TD><TD><P>Time2</P></TD><TD><P>Grp1</P></TD><TD><P>10543254</P></TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;</P><P>Bellow should be the final table</P><P>&nbsp;</P><TABLE><TBODY><TR><TD><P><STRONG>Want</STRONG></P></TD></TR><TR><TD><P><STRONG>ID</STRONG></P></TD><TD><P><STRONG>Time</STRONG></P></TD><TD><P><STRONG>Group</STRONG></P></TD><TD><P><STRONG>TimeDiff</STRONG></P></TD></TR><TR><TD><P>ID1</P></TD><TD><P>Time1</P></TD><TD><P>Grp1</P></TD><TD><P>24742462</P></TD></TR><TR><TD><P>ID1</P></TD><TD><P>Time2</P></TD><TD><P>Grp1</P></TD><TD><P>10598188</P></TD></TR><TR><TD><P>ID1</P></TD><TD><P>Time2</P></TD><TD><P>Grp2</P></TD><TD><P>1778177</P></TD></TR><TR><TD><P>ID1</P></TD><TD><P>Time2</P></TD><TD><P>Grp3</P></TD><TD><P>522</P></TD></TR><TR><TD><P>ID1</P></TD><TD><P>Time3</P></TD><TD><P>Grp3</P></TD><TD><P>9</P></TD></TR><TR><TD><P>ID1</P></TD><TD><P>Time3</P></TD><TD><P>Grp2</P></TD><TD><P>13046</P></TD></TR><TR><TD><P>ID1</P></TD><TD><P>Time3</P></TD><TD><P>Grp1</P></TD><TD><P>167599</P></TD></TR><TR><TD><P>ID1</P></TD><TD><P>Time4</P></TD><TD><P>Grp3</P></TD><TD><P>0</P></TD></TR><TR><TD><P>ID2</P></TD><TD><P>Time1</P></TD><TD><P>Grp1</P></TD><TD><P>11787936</P></TD></TR><TR><TD><P>ID2</P></TD><TD><P>Time2</P></TD><TD><P>Grp1</P></TD><TD><P>11762618</P></TD></TR><TR><TD><P>ID2</P></TD><TD><P>Time2</P></TD><TD><P>Grp3</P></TD><TD><P>0</P></TD></TR><TR><TD><P>ID2</P></TD><TD><P>Time2</P></TD><TD><P>Grp2</P></TD><TD><P>590</P></TD></TR><TR><TD><P>ID2</P></TD><TD><P>Time3</P></TD><TD><P>Grp1</P></TD><TD><P>4990</P></TD></TR><TR><TD><P>ID2</P></TD><TD><P>Time3</P></TD><TD><P>Grp3</P></TD><TD><P>0</P></TD></TR><TR><TD><P>ID2</P></TD><TD><P>Time3</P></TD><TD><P>Grp2</P></TD><TD><P>19738</P></TD></TR><TR><TD><P>ID2</P></TD><TD><P>Time4</P></TD><TD><P>Grp3</P></TD><TD><P>0</P></TD></TR></TBODY></TABLE> Sun, 27 Nov 2016 02:36:00 GMT shajisiva 2016-11-27T02:36:00Z How to Sum Vertically https://communities.sas.com/t5/SAS-Programming/How-to-Sum-Vertically/m-p/314528#M270824 <P>Hello All</P><P>&nbsp;</P><P>I have a table as follows</P><P>&nbsp;</P><P>ID : The ID is Unique value in the sense for a set of rows it will remains same , but the table may contain ID1, ID2,ID3,…IDn varies from case to case</P><P>Time : I have only 4 Values in the Table , Time1, Time2, Time 3 and Time4</P><P>Group : I have n different Groups starting from Grp1, Grp2, Grp3,…,Grpn from case to case</P><P>TimeDiff: Each row will be having a value and may vary from 0 to 123456789</P><P>&nbsp;</P><TABLE><TBODY><TR><TD><P><STRONG>Have</STRONG></P></TD></TR><TR><TD><P><STRONG>ID</STRONG></P></TD><TD><P><STRONG>Time</STRONG></P></TD><TD><P><STRONG>Group</STRONG></P></TD><TD><P><STRONG>TimeDiff</STRONG></P></TD></TR><TR><TD><P>ID1</P></TD><TD><P>Time1</P></TD><TD><P>Grp1</P></TD><TD><P>12371231</P></TD></TR><TR><TD><P>ID1</P></TD><TD><P>Time1</P></TD><TD><P>Grp1</P></TD><TD><P>12371231</P></TD></TR><TR><TD><P>ID1</P></TD><TD><P>Time2</P></TD><TD><P>Grp1</P></TD><TD><P>54934</P></TD></TR><TR><TD><P>ID1</P></TD><TD><P>Time2</P></TD><TD><P>Grp1</P></TD><TD><P>10543254</P></TD></TR><TR><TD><P>ID1</P></TD><TD><P>Time2</P></TD><TD><P>Grp2</P></TD><TD><P>1776401</P></TD></TR><TR><TD><P>ID1</P></TD><TD><P>Time2</P></TD><TD><P>Grp2</P></TD><TD><P>1776</P></TD></TR><TR><TD><P>ID1</P></TD><TD><P>Time3</P></TD><TD><P>Grp3</P></TD><TD><P>9</P></TD></TR><TR><TD><P>ID1</P></TD><TD><P>Time2</P></TD><TD><P>Grp3</P></TD><TD><P>522</P></TD></TR><TR><TD><P>ID1</P></TD><TD><P>Time4</P></TD><TD><P>Grp3</P></TD><TD><P>0</P></TD></TR><TR><TD><P>ID1</P></TD><TD><P>Time3</P></TD><TD><P>Grp2</P></TD><TD><P>13046</P></TD></TR><TR><TD><P>ID1</P></TD><TD><P>Time3</P></TD><TD><P>Grp1</P></TD><TD><P>167599</P></TD></TR><TR><TD><P>ID2</P></TD><TD><P>Time3</P></TD><TD><P>Grp1</P></TD><TD><P>4990</P></TD></TR><TR><TD><P>ID2</P></TD><TD><P>Time3</P></TD><TD><P>Grp3</P></TD><TD><P>0</P></TD></TR><TR><TD><P>ID2</P></TD><TD><P>Time2</P></TD><TD><P>Grp1</P></TD><TD><P>11762618</P></TD></TR><TR><TD><P>ID2</P></TD><TD><P>Time2</P></TD><TD><P>Grp3</P></TD><TD><P>0</P></TD></TR><TR><TD><P>ID2</P></TD><TD><P>Time2</P></TD><TD><P>Grp2</P></TD><TD><P>590</P></TD></TR><TR><TD><P>ID2</P></TD><TD><P>Time4</P></TD><TD><P>Grp3</P></TD><TD><P>0</P></TD></TR><TR><TD><P>ID2</P></TD><TD><P>Time3</P></TD><TD><P>Grp2</P></TD><TD><P>19738</P></TD></TR><TR><TD><P>ID2</P></TD><TD><P>Time1</P></TD><TD><P>Grp1</P></TD><TD><P>11787936</P></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I want to sum the TimeDiff if the Group having same value and Time having same value for each ID</P><P>&nbsp;</P><TABLE><TBODY><TR><TD><P><STRONG>Have</STRONG></P></TD><TD>&nbsp;</TD><TD><P><STRONG>Want</STRONG></P></TD></TR><TR><TD><P><STRONG>ID</STRONG></P></TD><TD><P><STRONG>Time</STRONG></P></TD><TD><P><STRONG>Group</STRONG></P></TD><TD><P><STRONG>TimeDiff</STRONG></P></TD><TD>&nbsp;</TD><TD><P><STRONG>ID</STRONG></P></TD><TD><P><STRONG>Time</STRONG></P></TD><TD><P><STRONG>Group</STRONG></P></TD><TD><P><STRONG>TimeDiff</STRONG></P></TD></TR><TR><TD><P>ID1</P></TD><TD><P>Time1</P></TD><TD><P>Grp1</P></TD><TD><P>12371231</P></TD><TD>&nbsp;</TD><TD><P>ID1</P></TD><TD><P>Time1</P></TD><TD><P>Grp1</P></TD><TD><P>24742462</P></TD></TR><TR><TD><P>ID1</P></TD><TD><P>Time1</P></TD><TD><P>Grp1</P></TD><TD><P>12371231</P></TD><TD>&nbsp;</TD><TD><P>ID1</P></TD><TD><P>Time2</P></TD><TD><P>Grp1</P></TD><TD><P>10598188</P></TD></TR><TR><TD><P>ID1</P></TD><TD><P>Time2</P></TD><TD><P>Grp1</P></TD><TD><P>54934</P></TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD><P>ID1</P></TD><TD><P>Time2</P></TD><TD><P>Grp1</P></TD><TD><P>10543254</P></TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;</P><P>Bellow should be the final table</P><P>&nbsp;</P><TABLE><TBODY><TR><TD><P><STRONG>Want</STRONG></P></TD></TR><TR><TD><P><STRONG>ID</STRONG></P></TD><TD><P><STRONG>Time</STRONG></P></TD><TD><P><STRONG>Group</STRONG></P></TD><TD><P><STRONG>TimeDiff</STRONG></P></TD></TR><TR><TD><P>ID1</P></TD><TD><P>Time1</P></TD><TD><P>Grp1</P></TD><TD><P>24742462</P></TD></TR><TR><TD><P>ID1</P></TD><TD><P>Time2</P></TD><TD><P>Grp1</P></TD><TD><P>10598188</P></TD></TR><TR><TD><P>ID1</P></TD><TD><P>Time2</P></TD><TD><P>Grp2</P></TD><TD><P>1778177</P></TD></TR><TR><TD><P>ID1</P></TD><TD><P>Time2</P></TD><TD><P>Grp3</P></TD><TD><P>522</P></TD></TR><TR><TD><P>ID1</P></TD><TD><P>Time3</P></TD><TD><P>Grp3</P></TD><TD><P>9</P></TD></TR><TR><TD><P>ID1</P></TD><TD><P>Time3</P></TD><TD><P>Grp2</P></TD><TD><P>13046</P></TD></TR><TR><TD><P>ID1</P></TD><TD><P>Time3</P></TD><TD><P>Grp1</P></TD><TD><P>167599</P></TD></TR><TR><TD><P>ID1</P></TD><TD><P>Time4</P></TD><TD><P>Grp3</P></TD><TD><P>0</P></TD></TR><TR><TD><P>ID2</P></TD><TD><P>Time1</P></TD><TD><P>Grp1</P></TD><TD><P>11787936</P></TD></TR><TR><TD><P>ID2</P></TD><TD><P>Time2</P></TD><TD><P>Grp1</P></TD><TD><P>11762618</P></TD></TR><TR><TD><P>ID2</P></TD><TD><P>Time2</P></TD><TD><P>Grp3</P></TD><TD><P>0</P></TD></TR><TR><TD><P>ID2</P></TD><TD><P>Time2</P></TD><TD><P>Grp2</P></TD><TD><P>590</P></TD></TR><TR><TD><P>ID2</P></TD><TD><P>Time3</P></TD><TD><P>Grp1</P></TD><TD><P>4990</P></TD></TR><TR><TD><P>ID2</P></TD><TD><P>Time3</P></TD><TD><P>Grp3</P></TD><TD><P>0</P></TD></TR><TR><TD><P>ID2</P></TD><TD><P>Time3</P></TD><TD><P>Grp2</P></TD><TD><P>19738</P></TD></TR><TR><TD><P>ID2</P></TD><TD><P>Time4</P></TD><TD><P>Grp3</P></TD><TD><P>0</P></TD></TR></TBODY></TABLE> Sun, 27 Nov 2016 02:36:00 GMT https://communities.sas.com/t5/SAS-Programming/How-to-Sum-Vertically/m-p/314528#M270824 shajisiva 2016-11-27T02:36:00Z Re: How to Sum Vertically https://communities.sas.com/t5/SAS-Programming/How-to-Sum-Vertically/m-p/314531#M270825 <P>You need a standard proc means. Look at the CLASS, TYPES, WAYS statements on how to create your groups.&nbsp;</P> <P>&nbsp;</P> <P>Alternatively, look at PROC SQL and include the identifiers in your GROUP BY statement.&nbsp;</P> Sun, 27 Nov 2016 02:57:12 GMT https://communities.sas.com/t5/SAS-Programming/How-to-Sum-Vertically/m-p/314531#M270825 Reeza 2016-11-27T02:57:12Z Re: How to Sum Vertically https://communities.sas.com/t5/SAS-Programming/How-to-Sum-Vertically/m-p/314534#M270826 <P>Reeza,</P><P>&nbsp;</P><P>Thanks for the reply . I am very new to SAS.</P><P>&nbsp;</P><P>Do you have a sample pgm or a doc something which I can refer.</P><P>&nbsp;</P><P>True Regards</P><P>Siva</P> Sun, 27 Nov 2016 03:08:45 GMT https://communities.sas.com/t5/SAS-Programming/How-to-Sum-Vertically/m-p/314534#M270826 shajisiva 2016-11-27T03:08:45Z Re: How to Sum Vertically https://communities.sas.com/t5/SAS-Programming/How-to-Sum-Vertically/m-p/314536#M270827 <P><A href="http://www2.sas.com/proceedings/sugi29/240-29.pdf" target="_blank">http://www2.sas.com/proceedings/sugi29/240-29.pdf</A></P> <P>&nbsp;</P> <P><A href="http://support.sas.com/training/tutorial/" target="_blank">http://support.sas.com/training/tutorial/</A></P> <P>&nbsp;</P> Sun, 27 Nov 2016 03:19:24 GMT https://communities.sas.com/t5/SAS-Programming/How-to-Sum-Vertically/m-p/314536#M270827 Reeza 2016-11-27T03:19:24Z Re: How to Sum Vertically https://communities.sas.com/t5/SAS-Programming/How-to-Sum-Vertically/m-p/320397#M270828 <P>Thanks Reeza</P><P>&nbsp;</P><P>It worked</P> Wed, 21 Dec 2016 03:46:07 GMT https://communities.sas.com/t5/SAS-Programming/How-to-Sum-Vertically/m-p/320397#M270828 shajisiva 2016-12-21T03:46:07Z