| Date: | Tue, 10 Oct 2006 15:49:24 -0500 |
|---|
| Reply-To: | Doug Cacialli <doug.cacialli@GMAIL.COM> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | Doug Cacialli <doug.cacialli@GMAIL.COM> |
|---|
| Subject: | Re: Rows into Columns |
|---|
| In-Reply-To: | <1160512886.451747.41640@b28g2000cwb.googlegroups.com> |
|---|
| Content-Type: | text/plain; charset=ISO-8859-1; format=flowed |
|---|
PROC TRANSPOSE will do the trick. You can find the syntax at:
http://www.tau.ac.il/cc/pages/docs/sas8/proc/z0063663.htm
There have been a lot of good papers presented over the years. A
google search on "PROC TRANSPOSE" will bring back a handful.
-D$.
On 10/10/06, 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
>
--
===
Douglas Cacialli, M.A. - Graduate student
Clinical Psychology Training Program
University of Nebraska-Lincoln
Lincoln, Nebraska 68588-0308
Ph: 402.304.7447 - smartphone@dougcacialli.org
E-mail: doug.cacialli@gmail.com
===
| 
