Hi...I am trying to insert a table from a second proc report below a table that was produced from the proc report. What I have been able to get so far is tables on separate pages from the first proc report and the last page has the table from the second proc report. This last table are the overall results and I would like that table to included on each page so I can compare the individual customers to the overall results. I have attached below the code I have so far....any help or suggestions would be greatly appreciated...thanks in advance. ... View more

Hi,   I am trying to create a report using ods pdf proc report and separating the dataset into separate tables on different pages using "BY Customer_Number". This part works fine. The problem I am having is that I would like extract the appropriate Customer_Number, Name and Address and placing these corresponding values in the title on each page that represent the appropriate data results. The dataset that I using for the report is similiar to the one below:   Customer_Number Name Address Item_Number Sale_Price 1654 Smith J. 123 Lowe 23127687 100.34 1654 Smith J. 123 Lowe 32146745 54.35 1721 Anderson B. 34 Buffalo 11450955 37.89 1922 Rae S. 6709 Mayfair 78663456 115.78     I would like the pdf file to look like the following where the first row is actually the title:   1654 Smith J. 123 Lowe   Item_Number Sale_Price   23127687 100.34   32146745 54.35     1721 Anderson B. 34 Buffalo   Item_Number Sale_Price   11450955 37.89     1922 Rae S. 6709 Mayfair   Item_Number Sale_Price   78663456 115.78   I wonder if someone can help...thanks... ... View more

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% ... View more