topic Re: I want the sum value if id is repeating like in the attachment with proc sql in SAS Programming

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

SrikanthY — Wed, 01 Feb 2017 12:00:47 GMT

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

RW9 — Wed, 01 Feb 2017 12:32:47 GMT

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 — Wed, 01 Feb 2017 14:08:57 GMT

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;