topic Re: How to display the group values on the first row of a new page in SAS Procedures

How to display the group values on the first row of a new page

odmhx — Tue, 15 Sep 2009 18:34:15 GMT

Using proc report, I am having trouble to display the group values on the first row of a new page when these group values are collapsed from previous page.

This is what I am having:

name id amount

last two row of revious page:

john 123 $12
.............$13
the first row of the next page:
.............$14.

I am trying to print the first row of the new page as this:
john 123 $14.

Any help is appreciated!

Re: How to display the group values on the first row of a new page

Tim_SAS — Wed, 16 Sep 2009 12:12:52 GMT

What kind of output are you producing? RTF? PDF? What version of SAS are you using?

Re: How to display the group values on the first row of a new page

odmhx — Wed, 16 Sep 2009 12:17:43 GMT

> What kind of output are you producing? RTF? PDF? What
> version of SAS are you using?

I am using rtf output and my SAS is SAS9.1.3 on AIX.

Re: How to display the group values on the first row of a new page

Tim_SAS — Wed, 16 Sep 2009 12:33:07 GMT

I don't have a solution, then. In 9.2 you can use PROC REPORT's new SPANROWS option. Sorry.

Re: How to display the group values on the first row of a new page

odmhx — Wed, 16 Sep 2009 12:38:48 GMT

> I don't have a solution, then. In 9.2 you can use
> PROC REPORT's new SPANROWS option. Sorry.

Thank you very much for your answer. I'll remember to update my program once I am on SAS9.2.