Hi All,   I have a sas report that has two sub totals named as 'TOTAL' (file attached). I would like to calculate the ''Grand Total' which I have colored in yellow.   I have tried using the following code to calculate the GRAND TOTAL but as expected it adds the sub totals as well and shows the result 76 in place of 38.    more code ....... rbreak after / SUMMARIZE style={color=yellow} ; compute after; Academics = 'GRAND TOTAL'; endcomp; run;     I have not created the "TOTAL" in the Proc report. Rather I have created them in Proc Sql and then used the UNION function to add it to the table before I created the Proc report.  Hence I am unsure of how to get the GRAND TOTAL which should select only the observations namely (leaving , new, old, continue, previous, Interna.)  to calculate the 'GRAND TOTAL'.   Please suggest the correct procedure.    Thank you!    Rs   ... View more

Hi All,   I am using SAS on demand for academics so I do not have access to ods output function.     I have two proc report outputs from two data frames.     the data frames are "test" and "test1"-    data test; input brand $ Freq Freq1 COUNT; datalines; A 2 3 8 B 3 5 4 C 4 6 2 D 5 1 1 E 6 5 8 F 7 7 9 ; run;   data test1; input cars $ Freq Freq1 COUNT; datalines; g 4 1 9 h 6 0 5 i 8 1 6 j 1 6 8 k 7 4 4 l 6 5 1 ; run;     The two proc reports that I get from the above data frames are as below -   proc report data=test nowd out=abs style(summary)=Header; title 'test'; column brand ('Enrollment' Freq Freq1 COUNT); define brand / group "Enrollment by Residency"; rbreak after / summarize; run;   proc report data=test1 nowd out=abs style(summary)=Header; title 'test1'; column cars ('Enrollment' Freq Freq1 COUNT); define cars / group "Enrollment by type"; rbreak after / summarize ; run;   The output of these reports are attached as "Output" . However, my desired output has sub headings in between the observations as in the attachment "Desired output"    Looking for some guidance on changing my "Output" to the "Desired output".     Thank you! ... View more