topic Re: A Question on collapsing records in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/A-Question-on-collapsing-records/m-p/186167#M47289 <HTML><HEAD></HEAD><BODY><P>Proc means/Proc Summary/Proc SQL. </P></BODY></HTML> Tue, 25 Nov 2014 18:02:57 GMT Reeza 2014-11-25T18:02:57Z A Question on collapsing records https://communities.sas.com/t5/SAS-Procedures/A-Question-on-collapsing-records/m-p/186166#M47288 <HTML><HEAD></HEAD><BODY><P>I have the following datatset with the following character variables&nbsp; (subject) and numeric variables <BR />(lob1&nbsp; lob2&nbsp;&nbsp; lob3)</P><P>subject&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; lob1&nbsp; lob2&nbsp;&nbsp; lob3<BR />-------&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ----&nbsp; -----&nbsp; ----<BR />10001&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4<BR />10001&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0<BR />10002&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp; 6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8<BR />10002&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7</P><P></P><P>I need to collapse the recored by subuject so the variables (lob1&nbsp; lob2&nbsp;&nbsp; lob3) have SUm by subject the result dataset should be as below:<BR />subject&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; lob1&nbsp; lob2&nbsp;&nbsp; lob3<BR />-------&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ----&nbsp; ----&nbsp;&nbsp; ----<BR />10001&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4<BR />10002&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp; 7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15</P></BODY></HTML> Tue, 25 Nov 2014 17:49:40 GMT https://communities.sas.com/t5/SAS-Procedures/A-Question-on-collapsing-records/m-p/186166#M47288 need_sas_help 2014-11-25T17:49:40Z Re: A Question on collapsing records https://communities.sas.com/t5/SAS-Procedures/A-Question-on-collapsing-records/m-p/186167#M47289 <HTML><HEAD></HEAD><BODY><P>Proc means/Proc Summary/Proc SQL. </P></BODY></HTML> Tue, 25 Nov 2014 18:02:57 GMT https://communities.sas.com/t5/SAS-Procedures/A-Question-on-collapsing-records/m-p/186167#M47289 Reeza 2014-11-25T18:02:57Z