Date: Wed, 15 Mar 2000 08:28:19 -0800
Reply-To: Ya Huang <ya.huang@AGOURON.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Ya Huang <ya.huang@AGOURON.COM>
Subject: Re: re-shaping data set
Content-Type: text/plain; charset=us-ascii
My favorite solution to this kind of prblem is again to use proc sql:
create table yourdata as
select distinct max(a) as a, max(b) as b, max(c) as c, max(d) as d
In gereneral, if your have "by" variable, you can just add a
"group by" statement.
Mahboobeh Safaeian wrote:
> Dear members
> i have a data set that looks like:
> Obs a b c d
> 1 373 . . .
> 2 . 1445 . .
> 3 . . 6 .
> 4 . . . 25
> i would like to make 1 line from the 4 lines so i have:
> obs a b c d
> 1 373 1445 6 25