Date:         Thu, 22 Oct 2009 11:23:05 -0400
Reply-To:     Ya Huang <ya.huang@AMYLIN.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Ya Huang <ya.huang@AMYLIN.COM>
Subject:      Re: Help need in Creating dataset based on the values of the
              other dataset
Comments: To: subrahmanyam.stat@GMAIL.COM

Looks like it's just a lag:

data need;
 set have;
ref1=lag(ref);
ref2=lag2(ref);
ref3=lag3(ref);
ref4=lag4(ref);
ref5=lag5(ref);
ref6=lag6(ref);
run;

On Thu, 22 Oct 2009 03:15:22 -0700, chengu <subrahmanyam.stat@GMAIL.COM>
wrote:

>Hi,
>
>Could anyone help me in this task?
>I am having one dataset with two variables like below.
>
>date             Ref
>13jun2006     1
>20jun2006     0.917
>27jun2006     0.716
>04jul2006      0.526
>11jul2006      0.234
>18jul2006      0.768
>
>I need dataset like
>
>date             Ref        Ref1     Ref2      Ref3     Ref4
>Ref5    Ref6
>13jun2006     1          1
>20jun2006     0.917    0.917    1
>27jun2006     0.716    0.716    0.917     1
>04jul2006      0.526    0.526   0.716    0.917     1
>11jul2006      0.234    0.234   0.526   0.716     0.917     1
>18jul2006      0.768    0.768   0.234    0.526    0.716     0.917
>1
>
>Thanks.