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-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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