topic how to refer to a previous value in longitudinal data set in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/how-to-refer-to-a-previous-value-in-longitudinal-data-set/m-p/145374#M38648 <HTML><HEAD></HEAD><BODY><P>I am working with a longitudinal data; students received a degree at a certain time; I wonder how I can change all the values to 1 after degree attainment. For example, this is what my data looks like now:</P><P></P><P>Id&nbsp;&nbsp;&nbsp;&nbsp; time&nbsp;&nbsp;&nbsp;&nbsp; award</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .</P><P></P><P></P><P>What I would like to do is to change the two missing values for time=5 and time=6 into 1. Any help is appreciated~!</P></BODY></HTML> Mon, 05 May 2014 20:34:14 GMT deerdi 2014-05-05T20:34:14Z how to refer to a previous value in longitudinal data set https://communities.sas.com/t5/SAS-Procedures/how-to-refer-to-a-previous-value-in-longitudinal-data-set/m-p/145374#M38648 <HTML><HEAD></HEAD><BODY><P>I am working with a longitudinal data; students received a degree at a certain time; I wonder how I can change all the values to 1 after degree attainment. For example, this is what my data looks like now:</P><P></P><P>Id&nbsp;&nbsp;&nbsp;&nbsp; time&nbsp;&nbsp;&nbsp;&nbsp; award</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .</P><P></P><P></P><P>What I would like to do is to change the two missing values for time=5 and time=6 into 1. Any help is appreciated~!</P></BODY></HTML> Mon, 05 May 2014 20:34:14 GMT https://communities.sas.com/t5/SAS-Procedures/how-to-refer-to-a-previous-value-in-longitudinal-data-set/m-p/145374#M38648 deerdi 2014-05-05T20:34:14Z Re: how to refer to a previous value in longitudinal data set https://communities.sas.com/t5/SAS-Procedures/how-to-refer-to-a-previous-value-in-longitudinal-data-set/m-p/145375#M38649 <HTML><HEAD></HEAD><BODY><P>Look up the lag function and retain statement.</P><P>And all the caveats that surround them <img id="smileyhappy" class="emoticon emoticon-smileyhappy" src="https://communities.sas.com/i/smilies/16x16_smiley-happy.png" alt="Smiley Happy" title="Smiley Happy" /></P></BODY></HTML> Mon, 05 May 2014 20:38:27 GMT https://communities.sas.com/t5/SAS-Procedures/how-to-refer-to-a-previous-value-in-longitudinal-data-set/m-p/145375#M38649 Reeza 2014-05-05T20:38:27Z Re: how to refer to a previous value in longitudinal data set https://communities.sas.com/t5/SAS-Procedures/how-to-refer-to-a-previous-value-in-longitudinal-data-set/m-p/145376#M38650 <HTML><HEAD></HEAD><BODY><P>I did....still have not figured out how to do it....Any ideas?</P></BODY></HTML> Mon, 05 May 2014 21:08:51 GMT https://communities.sas.com/t5/SAS-Procedures/how-to-refer-to-a-previous-value-in-longitudinal-data-set/m-p/145376#M38650 deerdi 2014-05-05T21:08:51Z