BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
GreyJoy
Obsidian | Level 7

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;
1 ACCEPTED SOLUTION
2 REPLIES 2
GreyJoy
Obsidian | Level 7

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. 

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 746 views
  • 0 likes
  • 2 in conversation