re: Proc Report

Accepted Solution Solved
Reply
Regular Contributor
Posts: 228
Accepted Solution

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
Super User
Posts: 7,694

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.

View solution in original post


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

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: 8,816

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.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 175 views
  • 0 likes
  • 3 in conversation