Proc Tabulate PctSum demominator error

[TMiles]

 I am having trouble calculating the % of total for the 2nd level in my nesting.  I get the error "PctSum base is not in table. A PctSum crossing has no denominator"

here is my code:

proc tabulate data=c2 missing;
class yrmon status item_status_at_order daysonsale;
var demandafterdisc;
table yrmon='' * ((status='' all=' ')
* demandafterdisc=' ' * f=dollar12. * sum=' ' demandafterdisc=' '*pctsum<status all>),
item_status_at_order=' ' all='Total' daysonsale=' ' all='Total';
format daysonsale sale. item_status_at_order $cmat.;
title1 ' ';
run;

[Astounding]

Here's the change I would try.  You now have this line:

* demandafterdisc=' ' * f=dollar12. * sum=' ' demandafterdisc=' '*pctsum<status all>),

Try this instead:

* (demandafterdisc=' ' * f=dollar12. * sum=' ' pctsum<status all>)),

As it stands now, the space before the second DEMANDAFTERDISC= means that the only classification variable being used is YRMON.

This recommendation untested, as you might imagine.  So let's see what happens.

[TMiles]

new error   -  maybe i'll just move the table without the % to EXCEL and calc...

ERROR: Statistic other than N was requested without analysis variable in the following nesting : yrmon * status * PctSum * item_status_at_order.
ERROR: Statistic other than N was requested without analysis variable in the following nesting : yrmon * status * PctSum * All.
ERROR: Statistic other than N was requested without analysis variable in the following nesting : yrmon * status * PctSum * daysonsale.
ERROR: Statistic other than N was requested without analysis variable in the following nesting : yrmon * status * PctSum * All.
ERROR: Statistic other than N was requested without analysis variable in the following nesting : yrmon * All * PctSum * item_status_at_order.
ERROR: Statistic other than N was requested without analysis variable in the following nesting : yrmon * All * PctSum * All.
ERROR: Statistic other than N was requested without analysis variable in the following nesting : yrmon * All * PctSum * daysonsale.
ERROR: Statistic other than N was requested without analysis variable in the following nesting : yrmon * All * PctSum * All.

[ballardw]

May want

* (demandafterdisc=' ' * f=dollar12. * (sum=' ' pctsum<status all>) )),

[TMiles · Accepted solution]

I was able to figure it after many tries -see below:


proc tabulate data=c2 missing;
class yrmon status item_status_at_order daysonsale;
var demandafterdisc;
table (yrmon='' * (status='' all=' ')
* demandafterdisc=' ' * (sum='Sales'*f=dollar12. pctsum<status all>='% of Total'*f=comma6.2)),
item_status_at_order=' ' all='Total' daysonsale=' ' all='Total';
format daysonsale sale. item_status_at_order $cmat.;
title1 ' ';
run;