BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
twildone
Pyrite | Level 9

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%

1 ACCEPTED SOLUTION

Accepted Solutions
RW9
Diamond | Level 26 RW9
Diamond | Level 26

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

2 REPLIES 2
RW9
Diamond | Level 26 RW9
Diamond | Level 26

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
SAS Super FREQ

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

sas-innovate-2024.png

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.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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