proc tabulate average under bottomline total possible??

Q1983 — Wed, 29 May 2019 15:28:29 GMT

data cars(keep= make type msrp cnt);

set sashelp.cars;

if make in ('Acura','BMW');

cnt=1;

run;

Proc tabulate =cars order= format=10. S=[cellwidth=80];

Class make type;

Var msrp cnt;

Table make='' all={label='Grand Total' S=[background = lightblue cellwidth=80]} *[STYLE=[Font_Weight=BOLD]],/*row*/

type*(cnt=''*sum='Count of Units' /*column*/

/*msrp=''*sum='MSRP$' *f=dollar16.2 /*msrp='' *colpctSum='% of MSRP'*f=number8.2*/ ) /*column*/

all={ label='Total' S=[background = lightblue]} *[STYLE=[Font_Weight=BOLD]] /*row total*/

*(cnt =' '*sum='Total Exceptions Units' msrp =' '*sum='Total MSRP Dollars$' *f=dollar16.2 /*row total detail*/

cnt=''*colpctn='Total % in Units' *f=number8.2 msrp=''*colpctSum='Total % in Dollars' *f=number8.2) /*row total detail*/

/ box='Car Summary';

keylabel n='';

run;

Is it possible to enter a statistic that captures the mean avg under the bottomline grand total? So for example for SUV the mean avg would be 1.5

Re: proc tabulate average under bottomline total possible??

ballardw — Wed, 29 May 2019 18:40:38 GMT

Please post code in a code box.

Please post code that actually runs if it should (your Proc tabulate statement has multiple missing elements especially DATA=)

If the question relates to calculations please do not include lots of style overrides and such. It makes it harder to reduce the to the basic question.

With Tabulate you are basically requesting statistics for either a row group or column. If you have statistics in the column, as SUM in this case , you cannot cross the SUM statistic with a MEAN for a single row.

You might want to use Proc Report as you could use a "compute after".

topic Re: proc tabulate average under bottomline total possible?? in SAS Programming

proc tabulate average under bottomline total possible??

Re: proc tabulate average under bottomline total possible??