topic Re: summarize proc report as sum and averages in New SAS User

summarize proc report as sum and averages

MattehWoo — Mon, 17 Dec 2018 16:21:08 GMT

Hi all,

I have a report that i've ran using Proc Report.

I want to summarize the data which i have done using:

rbreak after / dol skip summarize;

compute after;

Column='TOTAL';

endcomp;

Now this sums everything however, i have some columns that are average %s.

Is it possible to sum the columns with numbers but average the columns with the average percentages, or atleast blank them out, as at the moment the sum is showing 5000%+ which just looks well, dirty.

Any help is much appreciated.

Cheers,

Matt

Re: summarize proc report as sum and averages

ballardw — Mon, 17 Dec 2018 16:36:08 GMT

Incomplete code without data may lead to incomplete answers.

You could at least show your entire current code. Best would be to include some example data.

Averaging rates, such as percentages, is seldom appropriate.

Re: summarize proc report as sum and averages

Cynthia_sas — Mon, 17 Dec 2018 16:37:15 GMT

Hi:
Many things are possible with PROC REPORT. Here's a paper on BREAK processing https://support.sas.com/resources/papers/proceedings17/SAS0431-2017.pdf that may show you some techniques. And while this is a silly example http://support.sas.com/kb/38/776.html that changes age, height and weight variables to have a dollar format, it does show how you can use CALL DEFINE to change a format.

One reason you might be getting inflated percent numbers in the thousands is that if you are using the PERCENT format (which we can't see because you're not showing all your code) be aware that the PERCENT format does an automatic multiply by 100.

Your code snippet is interesting, but not helpful. You don't show any data. Or what ODS destination you're interested in DOL and SKIP are LISTING only options that will be ignored by ODS HTML, ODS RTF, ODS PDF and ODS EXCEL.

Cynthia

Re: summarize proc report as sum and averages

PaigeMiller — Mon, 17 Dec 2018 16:45:05 GMT

If ind that if you first do the math (average or totals or percentages) in PROC SUMMARY, then PROC REPORT works very nicely and easily.