percenatge change

[SASUser0001]

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

[PGStats · Accepted solution]

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;