topic Re: Subtract values of same variable? in SAS Enterprise Guide

Subtract values of same variable?

mdesessa — Wed, 10 Apr 2013 22:18:22 GMT

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:

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__ — Wed, 10 Apr 2013 22:37:23 GMT

Look in the online documentation for the DIF function.

Jagadishkatam — Thu, 11 Apr 2013 02:58:52 GMT

Hi,

You can try something like this as suggested by data_null_

data have;

input num;

substract=dif(num);

datalines;

;

run;

Thanks,

Jagadish