topic Re: how to construct lag variable in Statistical Procedures https://communities.sas.com/t5/Statistical-Procedures/how-to-construct-lag-variable/m-p/605834#M29425 <P>Thank you so much! it works!</P> Wed, 20 Nov 2019 16:31:39 GMT sfan6 2019-11-20T16:31:39Z how to construct lag variable https://communities.sas.com/t5/Statistical-Procedures/how-to-construct-lag-variable/m-p/605556#M29415 <P>I have the following data set,</P><P>&nbsp;</P><P>Ticker &nbsp; &nbsp;Year &nbsp; &nbsp;Net Income &nbsp; &nbsp; &nbsp; Net Income in year t-1</P><P>&nbsp; &nbsp;A &nbsp; &nbsp; &nbsp; &nbsp;2011 &nbsp; &nbsp; &nbsp; &nbsp;100</P><P>&nbsp; &nbsp;A &nbsp; &nbsp; &nbsp; &nbsp;2012 &nbsp; &nbsp; &nbsp; &nbsp;110 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 100</P><P>&nbsp; &nbsp;A &nbsp; &nbsp; &nbsp; &nbsp;2013 &nbsp; &nbsp; &nbsp; &nbsp;105 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 100</P><P>&nbsp; &nbsp;A &nbsp; &nbsp; &nbsp; &nbsp;2014 &nbsp; &nbsp; &nbsp; &nbsp;108 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 105</P><P>&nbsp; &nbsp;B &nbsp; &nbsp; &nbsp; &nbsp;2013 &nbsp; &nbsp; &nbsp; &nbsp;150</P><P>&nbsp; &nbsp;B &nbsp; &nbsp; &nbsp; &nbsp;2014 &nbsp; &nbsp; &nbsp; &nbsp;170 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 150</P><P>&nbsp; &nbsp;B &nbsp; &nbsp; &nbsp; &nbsp;2015 &nbsp; &nbsp; &nbsp; &nbsp;160 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 170</P><P>&nbsp;</P><P>How to construct the variable,&nbsp;Net Income in year t-1?&nbsp;</P> Tue, 19 Nov 2019 22:22:58 GMT https://communities.sas.com/t5/Statistical-Procedures/how-to-construct-lag-variable/m-p/605556#M29415 sfan6 2019-11-19T22:22:58Z Re: how to construct lag variable https://communities.sas.com/t5/Statistical-Procedures/how-to-construct-lag-variable/m-p/605561#M29416 LAG() <BR /><BR />data want;<BR />set have;<BR />by ticker; *assumes sorted;<BR /><BR />net_lag = lag(net_income);<BR />if first.ticker then call missing(net_lag);<BR />run; Tue, 19 Nov 2019 22:31:25 GMT https://communities.sas.com/t5/Statistical-Procedures/how-to-construct-lag-variable/m-p/605561#M29416 Reeza 2019-11-19T22:31:25Z Re: how to construct lag variable https://communities.sas.com/t5/Statistical-Procedures/how-to-construct-lag-variable/m-p/605834#M29425 <P>Thank you so much! it works!</P> Wed, 20 Nov 2019 16:31:39 GMT https://communities.sas.com/t5/Statistical-Procedures/how-to-construct-lag-variable/m-p/605834#M29425 sfan6 2019-11-20T16:31:39Z