## Calculate interval values

Solved
Frequent Contributor
Posts: 92

# Calculate interval values

HI there;

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

 ID value wants A 39 39 A 45 6 = 45-39 B 38 38 B 40 2 = 40-38 B 45 5 = 45-40 C 37 37 C 40 3 = 40-37 C 42 2 = 42-40 D 40 40

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

Hope it's not confused you.

Accepted Solutions
Solution
‎04-06-2017 02:54 PM
Super User
Posts: 6,781

## Re: Calculate interval values

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;

All Replies
Solution
‎04-06-2017 02:54 PM
Super User
Posts: 6,781

## Re: Calculate interval values

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;

Frequent Contributor
Posts: 92

## Re: Calculate interval values

Thank you very much, Astounding.