Subtraction

[WilliamB]

Hello,
I would like to calculate the subtraction of n and n-1

data table;

input n;

cards;

15

24

8

9

2

;

run;

and get in a table

N           S

15          .

24          9

8           -16

9             1

2             -7

Thanks for your help

[RW9]

data table;
  input n;
cards;
15
24
8
9
2
;
run;

data want;
 set table;
 if _n_ ne 1 then s=n - lag(n);
run;

[FredrikE · Accepted solution]

Just add:

s = n - lag(n);

//Fredrik

[Ksharp]

data table;
  input n;
cards;
15
24
8
9
2
;
run;

data want;
 set table;
 s=dif(n);
run;

[srinath3111]

data want;
set table;
want=n-lag(n);
run;