SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

how to roll out sequential data

Reply
Occasional Contributor
Posts: 7

how to roll out sequential data

Hi everyone, I have dataset A

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

Super Contributor
Posts: 490

Re: how to roll out sequential data

Posted in reply to xiaoqiuyin

data want (drop=lAZ);

set have;

lAZ=lag(AZ);

AZ=AZ / lAZ;

run;

Ask a Question
Discussion stats
  • 1 reply
  • 238 views
  • 1 like
  • 2 in conversation