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
Comments: To: Mahboobeh Safaeian <msafaeia@JHSPH.EDU>
Content-Type: text/plain; charset=us-ascii

Mahboobeh,

My favorite solution to this kind of prblem is again to use proc sql:

proc sql;
create table yourdata as
select distinct max(a) as a, max(b) as b, max(c) as c, max(d) as d
from yourdata
;

In gereneral, if your have "by" variable, you can just add a
"group by" statement.

HTH

Ya Huang

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
>
> thanks
>
> mahboobeh