https://communities.sas.com/t5/SAS-Procedures/toal-sale-in-same-dataset/m-p/69474#M19952 [pre]<BR /> data emp;<BR /> input eid $ job $ sale;<BR /> cards;<BR /> E101 CLERK 2000<BR /> E102 SALES 3000<BR /> E103 CLERK 4000<BR /> E102 SALES 2003<BR /> E103 CLERK 3009<BR /> E103 CLERK 4008<BR /> E102 SALES 2007<BR /> E102 SALES 3006<BR /> E101 CLERK 4005<BR /> ; <BR /> run;<BR /> proc means data=emp nway;<BR /> class eid job;<BR /> var sale;<BR /> output out=result(drop=_type_ _freq_) sum= /autoname;<BR /> run;<BR /> [/pre]<BR /> <BR /> <BR /> <BR /> Ksharp Thu, 17 Feb 2011 04:33:58 GMT Ksharp 2011-02-17T04:33:58Z https://communities.sas.com/t5/SAS-Procedures/toal-sale-in-same-dataset/m-p/69472#M19950 how can I keep the total sale of each emp in summarized format using base SAS only.<BR /> <BR /> E101 CLERK 6005<BR /> E102 SALES 10016<BR /> E103 CLERK 11017 <BR /> <BR /> data is like that<BR /> <BR /> data emp;<BR /> input eid $ job $ sale;<BR /> cards;<BR /> E101 CLERK 2000<BR /> E102 SALES 3000<BR /> E103 CLERK 4000<BR /> E102 SALES 2003<BR /> E103 CLERK 3009<BR /> E103 CLERK 4008<BR /> E102 SALES 2007<BR /> E102 SALES 3006<BR /> E101 CLERK 4005<BR /> ; Sat, 05 Feb 2011 20:08:47 GMT https://communities.sas.com/t5/SAS-Procedures/toal-sale-in-same-dataset/m-p/69472#M19950 deleted_user 2011-02-05T20:08:47Z https://communities.sas.com/t5/SAS-Procedures/toal-sale-in-same-dataset/m-p/69473#M19951 Only necessary to post in one forum - see your other post for a reply.<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc. Sat, 05 Feb 2011 21:53:48 GMT https://communities.sas.com/t5/SAS-Procedures/toal-sale-in-same-dataset/m-p/69473#M19951 sbb 2011-02-05T21:53:48Z https://communities.sas.com/t5/SAS-Procedures/toal-sale-in-same-dataset/m-p/69474#M19952 [pre]<BR /> data emp;<BR /> input eid $ job $ sale;<BR /> cards;<BR /> E101 CLERK 2000<BR /> E102 SALES 3000<BR /> E103 CLERK 4000<BR /> E102 SALES 2003<BR /> E103 CLERK 3009<BR /> E103 CLERK 4008<BR /> E102 SALES 2007<BR /> E102 SALES 3006<BR /> E101 CLERK 4005<BR /> ; <BR /> run;<BR /> proc means data=emp nway;<BR /> class eid job;<BR /> var sale;<BR /> output out=result(drop=_type_ _freq_) sum= /autoname;<BR /> run;<BR /> [/pre]<BR /> <BR /> <BR /> <BR /> Ksharp Thu, 17 Feb 2011 04:33:58 GMT https://communities.sas.com/t5/SAS-Procedures/toal-sale-in-same-dataset/m-p/69474#M19952 Ksharp 2011-02-17T04:33:58Z