As the first step in the decommissioning of sasCommunity.org the site has been converted to read-only mode.


Here are some tips for How to share your SAS knowledge with your professional network.


Tips:Using SPANROWS To Repeat Values Across Pages

From sasCommunity
Jump to: navigation, search
data class30;
set sashelp.class;
do check = 1 to 30;
    output;
    end;
run;
 
ods pdf file ='c:\temp\class30.pdf';
 
proc report data=class30 nowd out=show spanrows;
    column age name check sex;
    define age /order;
    define name / order ;
run;
ods pdf close;

The new (SAS 9.2) SPANROWS option on the PROC REPORT statement, provides a way to repeat the value of a GROUP or ORDER variable if that variable's value spans more than one page. The option works with RTF, PDF, and some other destinations. See a SAS Forum thread on this.


Submitted by Art Carpenter. Contact me at my Discussion Page.

....see also