how to roll out sequential data

Calcite | Level 5

Hi everyone, I have dataset A

I want it to be Y=Y/Lag(Y) , like Dataset B, any suggestions?

1 REPLY 1

Barite | Level 11

Re: how to roll out sequential data

Posted 01-23-2015 05:34 PM (1221 views) | In reply to xiaoqiuyin

data want (drop=lAZ);

set have;

lAZ=lag(AZ);

AZ=AZ / lAZ;

run;