Using Proc Tabulate, if you have a long cell for the first column that spans the first page, for some reason the output skips the first page and begins on the second.
With out changing PROCs and keeping the code for the Tabulate as close to the original as possible, how would I force the Proc to begin on the first page instead of having it skip to the second.
ODS RTF style=daisy File= "__PATH__\TEST SHEET.rtf" ;
ods rtf text= "~S={outputwidth=100% font=('Arial',10pt) just=l foreground=black background=CXD9DEF0} 1.1 WHY DOES THE TABLE NOT START HERE!?" ; * Title;
proc tabulate data=mapsgfk.us_states_attr format=7.0 style=[font=("Arial",9pt) ] ;
class isoname idname /
style=[ font=("Arial",9pt,bold) foreground=black background=CXD4E6F7] missing ;
table (isoname ="" *(all="Total N" idname="") ),
( all="Total") * (N COLPCTN*F=8.1)
/ box=[label=" "
style=[ font=("Arial",9pt) background= CXD4E6F7]]
misstext=" " ;
keylabel N="N" COLPCTN='%' ROWPCTN='%';
;
classlev isoname idname
/style= [ font=("Arial",9pt,bold)/* indent=10*/ foreground=black background=CXD4E6F7];
keyword N COLPCTN/style=[ font=("Arial",9pt,bold) foreground=black background=CXD4E6F7 ];
keyword ALL /style=[ font=("Arial",9pt,bold) foreground=black background=CXD4E6F7];
run; quit;
ods _all_ close;
Solved the original problem but the added another.
It did exactly what you should, but now the STARTPAGE=NOW options that i list throughout the document i am creating are ignored.
I will play around with it but THANK YOU for your help getting me to this point.
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.