Date:         Tue, 10 Oct 2006 18:53:13 -0400
Reply-To:     Arthur Tabachneck <art297@NETSCAPE.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Arthur Tabachneck <art297@NETSCAPE.NET>
Subject:      Re: Rows into Columns
Comments: To: sdlentert@AOL.COM

If it is a large data set you may want to simply use a data step.  It will
run more than 3 times faster than proc transpose.  For example:

data want (keep=Main F);
  set have;
  array thedata(20) F1-F20;
  do i=1 to 20;
    f=thedata(i);
    output;
  end;
run;

HTH,
Art
-------------
On Tue, 10 Oct 2006 13:41:26 -0700, sdlenter <sdlentert@AOL.COM> wrote:

>I have a table that has 21 fields (one main and 20 extra)
>Main   F1   F2   F3   F4        F20
>Adc    001  005  015  078    250
>Dfh    008  289  000  000   000
>
>
>I need to have only two columns Main and 1 extra  with all the F1
>through F20 numbers listed in one column instead of rows.. The final
>table will look like this:
>Main    F
>Adc    001
>Adc    005
>Adc    015
>Adc    078
>Adc    250
>Adc    015
>Dfh     008
>Dfh    289
>Dfh    000