topic how to roll out sequential data in SAS Data Management

topic how to roll out sequential data in SAS Data Management https://communities.sas.com/t5/SAS-Data-Management/how-to-roll-out-sequential-data/m-p/136242#M1983 <HTML><HEAD></HEAD><BODY><P>Hi everyone, I have dataset A</P><P></P><P>I want it to be   Y=Y/Lag(Y) , like Dataset B, any suggestions?</P><P><IMG alt="" class="jiveImage" src="https://communities.sas.com/legacyfs/online/8841_pastedImage_0.png" style="width: 401px; height: 459px;" /></P></BODY></HTML> Fri, 23 Jan 2015 22:12:01 GMT xiaoqiuyin 2015-01-23T22:12:01Z how to roll out sequential data https://communities.sas.com/t5/SAS-Data-Management/how-to-roll-out-sequential-data/m-p/136242#M1983 <HTML><HEAD></HEAD><BODY><P>Hi everyone, I have dataset A</P><P></P><P>I want it to be   Y=Y/Lag(Y) , like Dataset B, any suggestions?</P><P><IMG alt="" class="jiveImage" src="https://communities.sas.com/legacyfs/online/8841_pastedImage_0.png" style="width: 401px; height: 459px;" /></P></BODY></HTML> Fri, 23 Jan 2015 22:12:01 GMT https://communities.sas.com/t5/SAS-Data-Management/how-to-roll-out-sequential-data/m-p/136242#M1983 xiaoqiuyin 2015-01-23T22:12:01Z Re: how to roll out sequential data https://communities.sas.com/t5/SAS-Data-Management/how-to-roll-out-sequential-data/m-p/136243#M1984 <HTML><HEAD></HEAD><BODY><P>data want (drop=lAZ);</P><P>set have;</P><P>lAZ=lag(AZ);</P><P>AZ=AZ / lAZ;</P><P>run;</P></BODY></HTML> Fri, 23 Jan 2015 22:34:19 GMT https://communities.sas.com/t5/SAS-Data-Management/how-to-roll-out-sequential-data/m-p/136243#M1984 mohamed_zaki 2015-01-23T22:34:19Z