Date:         Tue, 8 Feb 2005 12:55:40 -0800
Reply-To:     Basem <batawfic@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Basem <batawfic@GMAIL.COM>
Organization: http://groups.google.com
Subject:      force long row to be printed into one page
Content-Type: text/plain; charset=ISO-8859-1

Dear All,

I'm using proc report below, the last column "ALL_3000" is very long
column ($4000) my problem is that all other columns are printed in one
page and this column is printed in another, I want all the columns
(for 1 row) to be printed in one page not matter how many pages it
takes, that is, I do not want the columns to be splited into two pages
and force proc report to include them all into 1 page.
Any ideas?
Thanks in advance

ODS LISTING CLOSE;
options date number nocenter pageno=1 orientation=LANDSCAPE LS=150;
ods pdf file=&output;
TITLE
  "Domain Analysis of SAS Dataset '&SASFNAME' (# of Records = &NOBS)";
proc report data=rpt nowd split='~'
     style(report)={cellspacing=1
                                        borderwidth=2 bordercolor=black}
     style(header)={foreground=black
          font_style=italic font_size=.5}
     style(column)={foreground=black
          font_face=helvetica font_size=.5}
     style(lines)={foreground=white background=black
          font_style=italic font_weight=bold font_size=.5}
     style(summary)={foreground=cx3e3d73 background=cxaeadd9
          font_face=helvetica font_size=1 just=r} ;
     columns name line nunique MISSING SPACES ZEROS statvar ALL_3000;
     define name    /
                        order 'Variable~Name';
     define line    /
                        display 'Type~(Raw format,~format)';
     define nunique /
                        display '# of~Unique Values~(Including Zeros)';
         define MISSING /
                        display '# of Missings~(For Numeric~Columns ONLY)';
         define SPACES /
                        display '# of Blanks~(For Character~Columns ONLY)';
         define ZEROS /
                        display '# of~Zeros';
     define statvar /
                        display 'Extreme Values~Min<Avg<Max~
                                        (Avg is Median for~Character Column)';
     define ALL_3000 / display      flow
                        "Values by Descending Frequency~
                        value1 (# of Occurences)~value2 (# of Occurences) ...";
        compute name;
                COUNT+1;
        if MOD(COUNT,2)=0  then DO;
                call define(_ROW_, "style", "STYLE={BACKGROUND=CX00FFFF}");
            END;
   endcomp;

   run ;
   quit ;
ods pdf close;
ODS LISTING;