| Date: | Mon, 31 Oct 2005 09:04:27 -0500 |
| Reply-To: | Tony Yang <tonyyangsxz@GMAIL.COM> |
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
| From: | Tony Yang <tonyyangsxz@GMAIL.COM> |
| Subject: | Re: A complicated data management problem |
|
| In-Reply-To: | <200510301112.j9U7LlTa010990@malibu.cc.uga.edu> |
| Content-Type: | text/plain; charset=ISO-8859-1 |
Thanks much, *Mehdi, I will try your code. *
**
Best regards,
Tony
On 10/30/05, Mehdi Soleymani <mehdi_soleymani@softhome.net> wrote:
>
> hi again,
> if you want the same output as you wrote you can use the follwing code on
> temp data which I wrote you before
>
> proc report data=temp out=final(drop=_break_) nowd;
> column id n1 l11 date n2 l12 l21 ;
> define id /group;
> run;
> data final;
> set final;
> if l21=. then l21=l11;
> if n1=. then n1=n2;
> run;
>
|