Help using Base SAS procedures

A Question on collapsing records

Reply
Contributor
Posts: 44

A Question on collapsing records

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

Super User
Posts: 17,730

Re: A Question on collapsing records

Proc means/Proc Summary/Proc SQL.

Ask a Question
Discussion stats
  • 1 reply
  • 146 views
  • 0 likes
  • 2 in conversation