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
> 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?
Look after Proc Transpose. it is brilliant :-)