topic Re: Proc Tabulate PctSum demominator error in SAS Procedures

Proc Tabulate PctSum demominator error

TMiles — Wed, 03 Aug 2016 19:03:11 GMT

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;

Re: Proc Tabulate PctSum demominator error

Astounding — Wed, 03 Aug 2016 19:13:50 GMT

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.

Re: Proc Tabulate PctSum demominator error

TMiles — Wed, 03 Aug 2016 19:16:56 GMT

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.

Re: Proc Tabulate PctSum demominator error

ballardw — Wed, 03 Aug 2016 19:50:12 GMT

May want

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

Re: Proc Tabulate PctSum demominator error

TMiles — Wed, 03 Aug 2016 20:29:32 GMT

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;