topic Re: subsequest values in SAS Programming

subsequest values

ursula — Tue, 11 Jul 2017 00:21:34 GMT

Hi there,

Please see below is what I try to get:

ID	visit	want
01	30	0
01	34	4	= 34-30
01	39	5	= 39-34
01	45	6	= 45-39
02	35	0	= 35-35
02	40	5	= 40-35
02	42	2	= 42-40

How to code in SAS to get the value in "want"?

any help will be very appriciate.

Thanks in advance!

Re: subsequest values

Jagadishkatam — Tue, 11 Jul 2017 00:44:51 GMT

data have;
input ID 	visit;
cards;
01 	30 	
01 	34 	
01 	39 	
01 	45 	
02 	35 	
02 	40 	
02 	42 	
;

data want;
set have;
by id visit;
want=visit-lag(visit);
if first.id then want=0;
run;

Re: subsequest values

ballardw — Tue, 11 Jul 2017 14:57:45 GMT

Minor change suggestion to @Jagadishkatam

data want;
   set have;
   by id;
   want = dif(visit);
   if first.id then want=0;
run;

The Dif function is the equivalent of : var- lag(var);

Re: subsequest values

ursula — Wed, 12 Jul 2017 16:18:27 GMT

Thank you so much for your prompt solution response.

I appreciated it.

Re: subsequest values

ursula — Wed, 12 Jul 2017 16:21:50 GMT

Thanks so much!!

it's very helpful!