topic Re: Proc report: how to show group variable across new pages in SAS Programming

Proc report: how to show group variable across new pages

jsbyxws — Sun, 09 Sep 2018 03:18:40 GMT

Hi, I think this question may be asked before. But I was unable to find it. Basically, I have group variable say Subject (Math, English etc), and another column: Student.

Subject Sudent

Math Student1

...

Math Student100

In proc report, I want to list Math only in first row of all pages with all Students. Define Subject as group can only accomplish this in first page. In next page under same subject (here math), it shows blank.

I tried rowspans but it seemed working different from what I want here. Can you help?

Re: Proc report: how to show group variable across new pages

ChrisNZ — Sun, 09 Sep 2018 22:46:51 GMT

Can you show an example of the desired output please?

Re: Proc report: how to show group variable across new pages

jsbyxws — Mon, 10 Sep 2018 00:34:12 GMT

Say page line limit is 65, in page 1, current output is
Math Student1
Student2
...
Studemt65

In page 2, it is
Student66
.
Student100

But I want Math also shows up in 2nd page and row 1 only, i.e. in page 2:

Math Sudent66
Student67
....
Student100

Re: Proc report: how to show group variable across new pages

ChrisNZ — Mon, 10 Sep 2018 02:29:56 GMT

Have you seen this this and this?

Re: Proc report: how to show group variable across new pages

jsbyxws — Mon, 10 Sep 2018 13:33:34 GMT

Thanks for help! Yes, I checked all three "this". The 2nd "this" wanted different result. The first case using "spanrows" actually moved page-broken section to next page - which is a bit different from what I want. The 3rd "this" is what I wanted to show but don't know how to modify its code to fit mine.

Re: Proc report: how to show group variable across new pages

jsbyxws — Wed, 12 Sep 2018 18:30:46 GMT

I created a sample data with 100 records grouped by variable "grp". Since one page can only hold say 60 records, the remaining 40 records will show up in next page. But in proc report, "grp" shows blank since it is group variable. I do want to show it in first observation in new page. Can you help?

data a;
do i=1 to 100;
grp="grp";
output;
end;

run;

ods rtf file="c:\ducoments\1.rtf";

proc report data=a ps=75;
column grp i;
define grp/group order=internal;
define i/display;
run;

ods rtf close;

Re: Proc report: how to show group variable across new pages

ChrisNZ — Thu, 13 Sep 2018 21:43:18 GMT

Mmm that's one for tech support I reckon.

Usage Note 53783 seems to work fine for PDF but not RTF on my 9.4M2 SAS version