Sum of rows

[proximo20]

My dataset looks like this

ID X

1001 5
1002 3
. .
. .
1002 4
1003 3
1003 6
1003 4
. .
. .
1003 3
1004 2
. .
. .
. .

Now I need only one ID and X value in each row. For example I need the sum of X values for the ID number 1002.

The problem is that the sequence always change. Sometimes I see the same Id number in the next three lines sometimes in the next 8 lines.

 

[dblan]

I'd use proc sql for this and sum X.

proc sql;
create table newtable as
select ID, sum(X) as SumofX
from yourtable
group by ID;
quit;

Dave

 

[ChrisW75]

Alternatively to keep this in native SAS:-

proc summary data=dset nway;
  class ID;
  var x;
  output out=new_dset(drop=_type_) sum=;
run;

Chris
Business Analyst, Code Monkey, Data Wrangler.
SAS Guru.