topic Generating new variable in SAS Enterprise Guide

Generating new variable

matt23 — Wed, 18 Jul 2018 19:33:12 GMT

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	...

Betreff: Generating new variable

Daniel_Paul — Wed, 18 Jul 2018 19:56:34 GMT

Hey,

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

Re: Generating new variable

novinosrin — Wed, 18 Jul 2018 20:11:39 GMT

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;

Re: Generating new variable

matt23 — Wed, 18 Jul 2018 20:18:04 GMT

thank you, sir