Date:         Sat, 16 Feb 2008 09:34:21 -0500
Reply-To:     Arthur Tabachneck <art297@NETSCAPE.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Arthur Tabachneck <art297@NETSCAPE.NET>
Subject:      Re: Data manipulation: Proc Transpose
Comments: To: Stefan Pohl <stefan.pohl@ISH.DE>

Stefan,

What are you asking?  You instructed proc transpose to turn six rows with
one column each into one row with six columns.

What were you expecting it to do?

Art
---------
On Sat, 16 Feb 2008 13:58:57 +0100, Stefan Pohl <stefan.pohl@ISH.DE> wrote:

>Hi sas-group,
>
>I have this data set:
>
>data test;
> input id : $100.;
> cards;
>1
>2
>3
>4_5_6
>7
>8_9
>;
>run;
>
>And I want to get this new data set:
>
>id1
>1 2 3 4_5_6 7 8_9
>
>First, I have transposed the column id:
>
>PROC TRANSPOSE DATA=test OUT=test_id (DROP = _NAME_)
>               prefix=idN;
> VAR id;
>RUN;
>
>And now? The code should manage different number of rows,
>not only 6 rows.
>
>Thank you for help.
>
>Stefan.