topic Proc Report with selected rows in ODS and Base Reporting

Proc Report with selected rows

MPaola — Mon, 04 Apr 2011 10:55:32 GMT

With a PROC REPORT is it possibile to put in output only those rows with a column value > x?

Example
Complete report:
GroupVariable_A |__B_|__C_|
aaaa __________|1000|2000|
bbbb __________|___0|___1|
cccc __________|5000|3000|

Desidered report (only rows with B >= 1000)
GroupVariable_A |__B_|__C_|
aaaa __________|1000|2000|
cccc __________|5000|3000|

Thanks
MPaola

Re: Proc Report with selected rows

Cynthia_sas — Mon, 04 Apr 2011 12:56:03 GMT

Hi:
It depends.

If B is based on a single observation, where GroupVariableA has been defined as a DISPLAY or ORDER variable, then a simple WHERE clause will eliminate the rows where _B is LT 1000 or GT X. However, if B is summarized based on your GroupVariable_A actually being defined with a usage of GROUP in PROC REPORT, then you will need to "pre-summarize" your data to determine which rows should "go forward" to PROC REPORT. There have been some previous postings on the subject, but it will be simple enough to do -- just use PROC MEANS, PROC SQL, PROC TABULATE and/or PROC REPORT to get summarized values and then eliminate the summarized rows that do not conform to what you want.

This does mean making 2 passes through the data. Just remember that any grand totals will not include those variables' values, if you eliminate the rows from the summary data -- unless you work on getting the numbers back in the total.

cynthia

Re: Proc Report with selected rows

Ksharp — Thu, 07 Apr 2011 09:31:37 GMT

And compute block will also can help you.

Ksharp

Re: Proc Report with selected rows

Ksharp — Thu, 07 Apr 2011 09:36:30 GMT

And compute block will also can help you.

Ksharp