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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.