## re: Proc Report

Solved
Regular Contributor
Posts: 247

# re: Proc Report

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%

Accepted Solutions
Solution
‎09-25-2015 06:23 AM
Super User
Posts: 9,599

## Re: re: Proc Report

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.

All Replies
Solution
‎09-25-2015 06:23 AM
Super User
Posts: 9,599

## Re: re: Proc Report

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.

SAS Super FREQ
Posts: 9,371

## Re: re: Proc Report

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

🔒 This topic is solved and locked.