toal sale in same dataset

[deleted_user]

how can I keep the total sale of each emp in summarized format using base SAS only.

E101 CLERK 6005
E102 SALES 10016
E103 CLERK 11017

data is like that

data emp;
input eid $ job $ sale;
cards;
E101 CLERK 2000
E102 SALES 3000
E103 CLERK 4000
E102 SALES 2003
E103 CLERK 3009
E103 CLERK 4008
E102 SALES 2007
E102 SALES 3006
E101 CLERK 4005
;

[sbb]

Only necessary to post in one forum - see your other post for a reply.

Scott Barry
SBBWorks, Inc.

[Ksharp]

[pre]
data emp;
input eid $ job $ sale;
cards;
E101 CLERK 2000
E102 SALES 3000
E103 CLERK 4000
E102 SALES 2003
E103 CLERK 3009
E103 CLERK 4008
E102 SALES 2007
E102 SALES 3006
E101 CLERK 4005
;
run;
proc means data=emp nway;
class eid job;
var sale;
output out=result(drop=_type_ _freq_) sum= /autoname;
run;
[/pre]



Ksharp