Subtract values of same variable?

[mdesessa]

Is there a way to subtract one value of a variable (column) from another value of the same variable?

For instance, I have a single column of numeric values:

1

2

3

4

5

and I want to subtract the first value in the column from the second (i.e. 2-1), the second value from the third, etc.

[data_null__ · Accepted solution]

Look in the online documentation for the DIF function.

[Jagadishkatam]

Hi,

You can try something like this as suggested by data_null_

data have;

  input num;

  substract=dif(num);

datalines;

1

2

3

4

5

;

run;

Thanks,

Jagadish