calculate percentages on breake

metallon — Thu, 03 Dec 2015 18:01:34 GMT

Hi SAS Experts,

I noticed that the the proc report sums the percentages on the breake. Which does not make sense in my case.

How can I "re"-calculate the percentages for the break/totals e.g. BIGORG_CODE?

proc report data=DATASELECT_BIGORG;
COLUMN BIGORG_CODE BIGORG_MATRIX MATRIX_GROUP_TEXT
('Source'
       ('COUNTRYX'(
                                 ('' COUNT_COUNTRYX)
                                         ('' RHG_COUNTRYX) )
                   ('' RHG_COUNTRYX_PERCENT)
                   ('' RHGBEANSTAN_COUNTRYX)
                   ('' RHGBEANSTAN_COUNTRYX_PERCENT))
);
DEFINE BIGORG_CODE / GROUP 'Code';
DEFINE MATRIX_GROUP_TEXT / 'Main Group';
DEFINE BIGORG_MATRIX / 'Matrix';

DEFINE COUNT_COUNTRYX / 'n';
DEFINE RHG_COUNTRYX / '>RHG';
DEFINE RHG_COUNTRYX_PERCENT / '%' format=nlnum20.1;

BREAK AFTER BIGORG_CODE / summarize style=[backgroundcolor=#C8CCA8 fontsize=1 fontfamily=arial];

/*coloring*/
COMPUTE RHG_COUNTRYX_PERCENT;
IF RHG_COUNTRYX_PERCENT.SUM > 1 AND RHG_COUNTRYX_PERCENT.SUM ne . THEN call define(_col_,"style","style={background=#2F75B5 foreground=white fontsize=1}");
ENDCOMP;
run;

Re: calculate percentages on breake

ballardw — Thu, 03 Dec 2015 18:39:49 GMT

Since you don't define a statistic in your DEFINE statements report is using the default SUM for the varaibles. Since Proc Report isn't calculating the percents but just lisint values you provided, it can't calculate a summary percent (at least not without a fair amount of work on your part for coding the summary).

topic calculate percentages on breake in ODS and Base Reporting

calculate percentages on breake

Re: calculate percentages on breake