The SAS Output Delivery System and reporting techniques

Proc tabulate cumulative frequency

Reply
N/A
Posts: 0

Proc tabulate cumulative frequency

How can i add a cumulative grand total to my proc tabulate report? OR is this even possible!

Here is my code:

PROC TABULATE data=RepCore.aggregate2 ;
CLASS week date signer APPOINTMENT sale;
VAR Num ;
TABLE week * (date='' ALL='Total Week') ALL='Park Total',
Signer='Region' * (N='Total' ROWPCTN='% For Day')
APPOINTMENT*(N PCTN *F=6.1)
SALE*(N PCTN *F=6.1)
ALL='Grand Total'/ MISSTEXT='0';

RUN; Just heard this is not possible :-( oh well back to the drawing board


Message was edited by: Jenzie
SAS Super FREQ
Posts: 8,864

Re: Proc tabulate cumulative frequency

Posted in reply to deleted_user
Hi:
Proc Report will let you calculate a cumulative column inside a COMPUTE block. And, a DATA step report would let you calculate a cumulative column.

The issue with PROC TABULATE is that it really only writes one cell at a time in one row at a time, so there is no visibility of the "previous" value in a previous report row and no ability to apply your own assignment statement to a column.

But since you do have this functionality with PROC REPORT or DATA step, it's just not possible with TABULATE.

cynthia
Ask a Question
Discussion stats
  • 1 reply
  • 1730 views
  • 0 likes
  • 2 in conversation