https://communities.sas.com/t5/SAS-Programming/how-to-report-the-total-sum-of-each-emp/m-p/69408#M15048 Thanks sir. Its working Sun, 06 Feb 2011 03:06:31 GMT deleted_user 2011-02-06T03:06:31Z https://communities.sas.com/t5/SAS-Programming/how-to-report-the-total-sum-of-each-emp/m-p/69404#M15044 I want to report the total sale of each emp in summarized format in base SAS only without using SQL.<BR /> <BR /> data is like that<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 /> output should be like this (total sum of sale)<BR /> E101 CLERK 6005<BR /> E102 SALES 10016<BR /> E103 CLERK 11017 Sat, 05 Feb 2011 19:14:08 GMT https://communities.sas.com/t5/SAS-Programming/how-to-report-the-total-sum-of-each-emp/m-p/69404#M15044 deleted_user 2011-02-05T19:14:08Z https://communities.sas.com/t5/SAS-Programming/how-to-report-the-total-sum-of-each-emp/m-p/69405#M15045 Look at either PROC REPORT or consider using PROC SUMMARY along with PROC PRINT, or PROC MEANS. The SAS support website <A href="http://support.sas.com/" target="_blank">http://support.sas.com/</A> has much to offer, with SAS-hosted documentation and also technical / conference reference material - suggest using the SEARCH facility there or use a Google advanced search, possibly, by coding the parameter "site:sas.com" to limit your search.<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc. Sat, 05 Feb 2011 19:23:27 GMT https://communities.sas.com/t5/SAS-Programming/how-to-report-the-total-sum-of-each-emp/m-p/69405#M15045 sbb 2011-02-05T19:23:27Z https://communities.sas.com/t5/SAS-Programming/how-to-report-the-total-sum-of-each-emp/m-p/69406#M15046 Sorry for my wrong way of asking the question. <BR /> sir, is it possible that the same dataset (emp) should contain the total sale of every emp like the below output. <BR /> E101 CLERK 6005<BR /> E102 SALES 10016<BR /> E103 CLERK 11017 Sat, 05 Feb 2011 19:42:34 GMT https://communities.sas.com/t5/SAS-Programming/how-to-report-the-total-sum-of-each-emp/m-p/69406#M15046 deleted_user 2011-02-05T19:42:34Z https://communities.sas.com/t5/SAS-Programming/how-to-report-the-total-sum-of-each-emp/m-p/69407#M15047 Based on the "output data" demonstrated, the SAS PROC SUMMARY can create a new file (or replace the existing file, as preferred) using the CLASS, VAR and OUTPUT statements.<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc.<BR /> <BR /> Suggested Google advanced search argument, this topic / post:<BR /> proc summary site:sas.com Sat, 05 Feb 2011 21:52:51 GMT https://communities.sas.com/t5/SAS-Programming/how-to-report-the-total-sum-of-each-emp/m-p/69407#M15047 sbb 2011-02-05T21:52:51Z https://communities.sas.com/t5/SAS-Programming/how-to-report-the-total-sum-of-each-emp/m-p/69408#M15048 Thanks sir. Its working Sun, 06 Feb 2011 03:06:31 GMT https://communities.sas.com/t5/SAS-Programming/how-to-report-the-total-sum-of-each-emp/m-p/69408#M15048 deleted_user 2011-02-06T03:06:31Z