topic Re: PROC REPORT does not repeat values of GROUP/ORDER variables in ODS in ODS and Base Reporting

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

IJU — Mon, 10 Nov 2008 20:10:40 GMT

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

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

Tim_SAS — Mon, 10 Nov 2008 21:04:40 GMT

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.

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

IJU — Tue, 11 Nov 2008 19:18:56 GMT

Thank you, Tim.
It works now.

Regards,
IJU

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

IJU — Thu, 13 Nov 2008 16:12:18 GMT

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

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

IJU — Thu, 13 Nov 2008 16:29:33 GMT

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