I have the following datatset with the following character variables (subject) and numeric variables
(lob1 lob2 lob3)
subject lob1 lob2 lob3
------- ---- ----- ----
10001 0 1 4
10001 1 0 0
10002 5 6 8
10002 0 1 7
I need to collapse the recored by subuject so the variables (lob1 lob2 lob3) have SUm by subject the result dataset should be as below:
subject lob1 lob2 lob3
------- ---- ---- ----
10001 1 1 4
10002 5 7 15