Condensing data sets

[shukuchi]

Hi, I have a question on condensing data sets.

For example, how do I change this dataset:

ID Deposit
1 100
1 150
2 50
2 50
2 50
3 75

Into this:
ID Deposit
1 250
2 150
3 75

I am sorting the dataset by ID and I know I might have to use the first. and last. functions, but I'm new to SAS and I can't come up with a solution.

Any help would be appreciated.

[Flip]

Proc sql;
select id, sum(deposit) deposit from xxx group by id;
quit;

[DanielSantos]

Or.
[pre]
proc summary data=INDATA nway missing;
class ID; * group var;
var DEPOSIT; * statistic var;
output out=OUTDATA sum= (drop=_TYPE_ _FREQ_);
run;
[/pre]
Cheers from Portugal

Daniel Santos @ www.cgd.pt

[abdullala]

or:
proc sort data=xxx nodup;
by id;
run;

[abdullala]

ah, misunderstood the request. ignore please!!!