I want the sum value if id is repeating like in the attachment with proc sql

[SrikanthY]

if ID is > 1 then sum of edate - stdate
else just retain the edate - stdate in varibale

[RW9]

Post test data in the form of a datastep, and required output.  I am not here to type in test data to provide you code.

[Astounding]

Based on your diagram, this looks like it might do the trick:

data want;

Rvalue=0;

do until (last.id);

   set have;

   by id;

   Rvalue + (edate - stdate);

end;

do until (last.id);

   set have;

   by id;

   subvalue = edate - stdate;

   output;

end;

run;