re: Proc Report

[twildone]

Hi...I am using PROC REPORT to generate the following table. I would like to insert a 'Total' row just above Overall which would be the sum of New and Renewal. Any suggestions...Thanks.

Request Type	Unique Number of Customers	Number of Requests	Percent of Requests
New	30657	34838	62.14%
Renewal	17832	21223	37.86%
Overall	43800	56061	100.00%

I would liek the end up with the following table:

Request Type	Unique Number of Customers	Number of Requests	Percent of Requests
New	30657	34838	62.14%
Renewal	17832	21223	37.86%
Total	48489	56061	100.00%
Overall	43800	56061	100.00%

[RW9 · Accepted solution]

Personally I would do it in a datastep before:

data want (drop=lstcust lstreq lstpcent);

  set have;

  retain lstcust lstreq lstpcent;

  if type="New" then do;

    lstcust=cust;

    lstreq=req;

    lstpcent=pcent;

  end;

  if type="Renewal" then do;

    output;

    type="Total";

    cust=sum(cust,lstcust);

    req=sum(req,lstreq);

    pcent=sum(pcent,lstpcent);

    output;

  end;

  else output;

run;

Although is an odd request, in what way does total differ from Overall?  I would work it into the creation of the dataset from which you get those numbers.

[Cynthia_sas]

Hi:

  What code have you tried? And, how are you generating the data right now? This looks like pre-summarized data already. If they data doesn't come to you with Total, what is the purpose of the Total line. It looks exactly the same at Overall except for the first column. What is your destination of interest? RTF, PDF, HTML???

cynthia