topic Re: Summarize detail;proc summary, tabulate or proc report in ODS and Base Reporting

Summarize detail;proc summary, tabulate or proc report

omega1983 — Fri, 29 Nov 2013 21:31:31 GMT

I have enclosed a spreadsheet example of desired output. I have a column of data that needs to have header names added and summarized. I am trying to determine the best way to do this.

It involves assigning variable names and using in the summary report. The totals have already been calculated. See enclosed

Re: Summarize detail;proc summary, tabulate or proc report

Cynthia_sas — Sat, 30 Nov 2013 04:28:32 GMT

Hi:

I'm curious why you asked about PROC SUMMARY and if it would help you. If you have already summarized your data, where does PROC SUMMARY come into the picture? Is that what you used to summarize the data?

What code have you tried? What does your input data look like?

Your spreadsheet had several sections...which rows/columns represent the input data? What is the row for 'NOTH'? Why do you have 2 sections for MSB, one with numbers and another with zeroes? It is hard to make constructive recommendations without enough information.

cynthia

Re: Summarize detail;proc summary, tabulate or proc report

omega1983 — Sat, 30 Nov 2013 22:44:45 GMT

Here is the datastep

data Status(keep=Investor Comp_Ratio Sales Returns Goal);

set Status1;

run;

I want to display a report tab that will show Investor as a header

I want to do a variable named Categories and Performance and show the already assigned Goal

Categories would show sales and returns as rows and the Performance as the Column, along with Goal

Comp_Ratio would show as a row at the bottom of each header.

It looks like a proc transpose however I think I need to know how to handle Categories and Performance

Re: Summarize detail;proc summary, tabulate or proc report

Cynthia_sas — Sun, 01 Dec 2013 05:26:08 GMT

Hi:

But that doesn't show what is in Status1. What does the data in Status1 look like? How is it created -- do you use a procedure to create STATUS1? It is in the WORK library. How does it get there? It looks like your DATA step program is only being used to keep the 4 variables. You didn't answer my question about what is row for "NOTH" in your example? Since you need both comma formats and percent signs in the Performance column, that is an argument for PROC REPORT for the final report. But there are still too many unknowns for the report code, when the data manipulation is still not resolved.

cynthia.