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% |
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.
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.
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
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.