Help using Base SAS procedures

toal sale in same dataset

Reply
N/A
Posts: 0

toal sale in same dataset

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
;
Super Contributor
Super Contributor
Posts: 3,174

Re: toal sale in same dataset

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

Scott Barry
SBBWorks, Inc.
Super User
Posts: 9,662

Re: toal sale in same dataset

[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
Ask a Question
Discussion stats
  • 2 replies
  • 267 views
  • 0 likes
  • 3 in conversation