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.
Thanks in advace.
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;
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;
Thank you very much, Astounding.
I appreciate your prompt response!
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.