https://communities.sas.com/t5/SAS-Programming/Rollup/m-p/15255#M1984 Is there a Rollup (sql function) or similar function in SAS to get the total or subtotal ?<BR /> <BR /> Thanks Tue, 22 Feb 2011 20:33:54 GMT newbi 2011-02-22T20:33:54Z https://communities.sas.com/t5/SAS-Programming/Rollup/m-p/15255#M1984 Is there a Rollup (sql function) or similar function in SAS to get the total or subtotal ?<BR /> <BR /> Thanks Tue, 22 Feb 2011 20:33:54 GMT https://communities.sas.com/t5/SAS-Programming/Rollup/m-p/15255#M1984 newbi 2011-02-22T20:33:54Z https://communities.sas.com/t5/SAS-Programming/Rollup/m-p/15256#M1985 IN PROC SQL, there are several. Check the documentation for "summary functions." I don't recall one being called "rollup", but SUM provides subtotals or a total. Tue, 22 Feb 2011 21:25:38 GMT https://communities.sas.com/t5/SAS-Programming/Rollup/m-p/15256#M1985 Doc_Duke 2011-02-22T21:25:38Z https://communities.sas.com/t5/SAS-Programming/Rollup/m-p/15257#M1986 Hi:<BR /> In addition to Doc's suggestion, SAS has reporting procedures like PROC MEANS, PROC TABULATE and PROC REPORT that will produce summary reports (that would only show the subtotals and/or grand totals). PROC REPORT and PROC PRINT have the ability to create "detail" reports where the subtotals and grandtotals are added to the report as extra summary lines. (For purposes of explanation, a detail report contains one report row for every observation in your original dataset or subset, with additional summary lines added to the report; a summary report contains one report row for every summarized group of observations, with additional summary lines added to the report for subtotals and grand totals.)<BR /> <BR /> Some SQL queries are used for reporting purposes, and if this is your goal, then you might investigate the SAS reporting procedures mentioned above (to name just a few).<BR /> <BR /> cynthia Wed, 23 Feb 2011 02:35:13 GMT https://communities.sas.com/t5/SAS-Programming/Rollup/m-p/15257#M1986 Cynthia_sas 2011-02-23T02:35:13Z