topic Subtraction in SAS Programming

Subtraction

WilliamB — Wed, 31 Jan 2018 13:49:08 GMT

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

data table;

input n;

cards;

;

run;

and get in a table

N S

15 .

24 9

8 -16

9 1

2 -7

Thanks for your help

RW9 — Wed, 31 Jan 2018 13:53:10 GMT

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 — Wed, 31 Jan 2018 13:56:37 GMT

Just add:

s = n - lag(n);

//Fredrik

Ksharp — Wed, 31 Jan 2018 14:19:26 GMT


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

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

srinath3111 — Wed, 31 Jan 2018 14:27:54 GMT

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