topic Condensing data sets in SAS Procedures

Condensing data sets

shukuchi — Thu, 21 Jan 2010 15:48:30 GMT

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.

Re: Condensing data sets

Flip — Thu, 21 Jan 2010 15:50:40 GMT

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

Re: Condensing data sets

DanielSantos — Thu, 21 Jan 2010 16:36:04 GMT

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

Re: Condensing data sets

abdullala — Thu, 21 Jan 2010 17:59:11 GMT

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

Re: Condensing data sets

abdullala — Thu, 21 Jan 2010 18:00:28 GMT

ah, misunderstood the request. ignore please!!!