Generating new variable

[matt23]

I have this type of data:

Hour	X
0	70232
1	68422
2	67014
3	66068
4	65781
5	66308
6	67559
7	69150
8	69788
9	70685

and I'd like to have a delta(x) as a new variable delta(x) = Next - Current so the data would look like this:

Hour	X	Delta X
0	70232	-1810
1	68422	-1408
2	67014	...
3	66068	...
4	65781	...
5	66308	...
6	67559	...
7	69150	...
8	69788	...
9	70685	...

[Daniel_Paul]

Hey,

you can find a solution in this post Difference between values in two rows  

---

[novinosrin · Accepted solution]

data have;
input Hour	X;
cards;
0	70232
1	68422
2	67014
3	66068
4	65781
5	66308
6	67559
7	69150
8	69788
9	70685
;

data want;
merge have have(firstobs=2 rename=(x=_x));
delta=_x-x;
drop _x;
run;

[matt23]

thank you, sir