The SAS Output Delivery System and reporting techniques

PROC REPORT does not repeat values of GROUP/ORDER variables in ODS

Reply
Occasional Contributor IJU
Occasional Contributor
Posts: 10

PROC REPORT does not repeat values of GROUP/ORDER variables in ODS

According to the note at http://support.sas.com/kb/7/887.html the Problem note 7887: "PROC REPORT does not repeat values of GROUP/ORDER variables when groups break across pages( for the ODS destination)" has been fixed in SAS 9.2.
We have started using SAS 9.2 on XP_PRO platform: the bug is still there.
Has this problem been fixed or not?

Thanks,
IJU
Super Contributor
Posts: 394

Re: PROC REPORT does not repeat values of GROUP/ORDER variables in ODS

Try using the new SPANROWS option on the proc statement:

proc report data=xyz nowd SPANROWS ...;

If your output is RTF you must use the new tagsets.rtf destination.
Occasional Contributor IJU
Occasional Contributor
Posts: 10

Re: PROC REPORT does not repeat values of GROUP/ORDER variables in ODS

Hi Tim:

The SPANROWS option works in both ODS PDF and tagsets.rtf destination. But I cannot get the pageOf feature to work now. Is there a solution with both GROUP/ORDER variables repeated on a page and the pageOf feature?

Thanks,
IJU
Occasional Contributor IJU
Occasional Contributor
Posts: 10

Re: PROC REPORT does not repeat values of GROUP/ORDER variables in ODS

Hi Tim:

Sorry. Could you please ignore my previous reply. The PageOf option works in ODS with  and  variables and a correct escape character statement.

Thanks,

IJU

Occasional Contributor IJU
Occasional Contributor
Posts: 10

Re: PROC REPORT does not repeat values of GROUP/ORDER variables in ODS

Thank you, Tim.
It works now.

Regards,
IJU
Ask a Question
Discussion stats
  • 4 replies
  • 229 views
  • 0 likes
  • 2 in conversation