topic Re: Compute quantity in a recursive way in SAS Programming

Compute quantity in a recursive way

mark_ph — Sun, 20 Dec 2015 23:35:05 GMT

Dear All,

I have the following dataset:

data have;
   input id V1 V2;
datalines;
1  10   3
1   .   4
1   .   5
2  20   5
2   .   7
2   .   8;

I would like to obtain the following dataset want. That is, I want

V1 = lag(V1)+V2 for those observations such that first.id is not true (starting from the second one of each id group)

data want;
   input id V1 V2;
datalines;
1  10   3
1  14   4
1  19   5
2  20   5
2  27   7
2  35   8;

Any help would e highly appreciated.

mohamed_zaki — Sun, 20 Dec 2015 23:34:50 GMT

data want (drop=lag_v1) ;
set have;
by id;
lag_v1=lag(V1);
if first.id then V3=V1;
else V3=lag_v1+4;
run;

I think you have mistaken the value of V3 in the last row in your data want

mark_ph — Sun, 20 Dec 2015 23:37:06 GMT

Dear @mohamed_zaki, I'm really sorry. I did a mistake including V3 in my previous toy example. I have just updated it.

mohamed_zaki — Sun, 20 Dec 2015 23:55:33 GMT

If this is what you want then you do not need Lag()

data want (drop=v12sum);
set have;
by id;
retain v12sum;
if first.id then v12sum=v1;
else do ;
v12sum=v12sum+v2;
v1=v12sum;
end;

Jagadishkatam — Mon, 21 Dec 2015 03:39:09 GMT

Though the solution is already provided, here is an alternative approach.

Hope you like it.

data want;
set have(rename=v1=_v1);
retain v1;
by id;
if first.id then v1=_v1;
else v1=sum(v1,v2);
run;