Date:         Thu, 13 Oct 2005 20:13:30 +0200
Reply-To:     Jan Selchau-Hansen <mit_fornavn@MIT_EFTERNAVN.DK>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Jan Selchau-Hansen <mit_fornavn@MIT_EFTERNAVN.DK>
Organization: TDC Totalloesninger
Subject:      Re: converting database from many rows/ subject to one row/subject
Comments: To: sas-l@uga.edu

julicun@hotmail.com wrote:
> Hi--
> I'm a novice SAS user, and I'm having trouble with what I suspect is a
> pretty easy database transformation.  I currently have a database with
> two variables: an ID number, and an observation (call it x).  I need
> to convert it to a format that has one row per ID, with variables x1,
> x2, x3, etc.
>
> I've consulted my SAS texts and I see how to do this if I want only
> the first or last observation, or the mean, etc.  But I want to
> retain all the data; I just need it in a different structure.  Does
> anyone have suggestions?
>
> Thanks!!
>
> Julie
Hi Julie,

Look after Proc Transpose. it is brilliant :-)

Jan Selchau-Hansen