percenatge change

SASUser0001 — Wed, 27 May 2020 02:18:27 GMT

data want;

set a;

rel_diff=abs((amount1-amount2)/amount1);



format rel_diff percent5.0;

run;

</>

hi The following program shows between two variables but I am looking to get percentage change between two number in a variable.

my data is like this

date Range

31-Mar-80 1800

30-Jun-80 1300

30-Sep-80 800

31-Dec-80 300

31-Mar-81 600

30-Jun-81 900

Re: percenatge change

PGStats — Wed, 27 May 2020 03:47:43 GMT

Use the DIF and LAG functions to refer to the previous value:

data want;
set a;
rel_diff = abs( dif(range) / lag(range) );
format rel_diff percent5.0;
run;