topic Calculate interval values in SAS Programming

Calculate interval values

ursula — Thu, 06 Apr 2017 18:25:48 GMT

HI there;

I would like to calculate the interval between values by ID, as following:

the column 'wants' is what I want to get.

Hope it's not confused you.

Thanks in advace.

Astounding — Thu, 06 Apr 2017 18:49:12 GMT

SAS knows how to do this, as long as your data set is sorted by ID:

data want;

set have;

by ID;

wants = dif(value);

if first.id then wants = value;

run;

ursula — Thu, 06 Apr 2017 18:54:54 GMT

Thank you very much, Astounding.

I appreciate your prompt response!