Date:         Tue, 15 Mar 2005 09:27:16 -0500
Reply-To:     "Richard A. DeVenezia" <radevenz@IX.NETCOM.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Richard A. DeVenezia" <radevenz@IX.NETCOM.COM>
Subject:      Re: Presenting a wide table in one page
Comments: To: sas-l@uga.edu

shavit_tal wrote:
> Hi,
>
> I need to present a wide table which consists of 200 observations,
> each observation has 20 variables to appear in the columns - say they
> are study_num, var1-var19. I'm using proc tabulate to present the
> data. Now the output is a wide table containing 12 variables out of
> the 20 that continues on 4 pages (study_num and var1-var11), and then
> the rest of the variables, var12-var19, are presented for additional
> 4 pages.
>
> I'd like to present it in a different format to ease the understanding
> of the readers: either to tabulate each observation into 2 consequent
> rows (first row - study_num + var1-var9, second row- study_num +
> var10-var19) or, at least on 2 consequent pages.
> I'd appreciate any suggestions.
>
> Thanks in advance,
> Shavit

What is the destination ?
Did you consider using Proc PRINT or DATA Step?


Here are some samples:
---------------
data foo;
  do study_num = 1 to 1;
    do rowid = 1 to 200;
      array v(19);
      do i = 1 to dim(v);
        count + 1;
        v(i) = count;
      end;
      output;
    end;
  end;
  drop rowid i count;
run;

options pageno=1 nocenter linesize=125;

dm output 'clear' ;

data _null_;
  set foo (obs=3);
  file print;
  put / study_num (v1-v9) (best12.);
  put study_num (v10-v19) (best12.);
run;


data _null_;
  set foo (obs=3);
  file print;
  put / study_num (v1-v9) (=best12.);
  put study_num (v10-v19) (=best12.);
run;

options linesize=80;

proc print data=foo;
run;
---------------




--
Richard A. DeVenezia
http://www.devenezia.com/downloads/sas/actions for SAS Explorer