DATA Step, Macro, Functions and more

Calculate interval values

Accepted Solution Solved
Reply
Contributor
Posts: 64
Accepted Solution

Calculate interval values

HI there;

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

 

ID value wants  
39 39  
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.

 

Thanks in advace.


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

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;

View solution in original post


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

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;

Contributor
Posts: 64

Re: Calculate interval values

Thank you very much, Astounding.

I appreciate your prompt response!

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 105 views
  • 1 like
  • 2 in conversation