topic Re: Calculating day span across longitudinal data in SAS Programming

Calculating day span across longitudinal data

rupalif — Fri, 01 Aug 2014 16:08:58 GMT

Hi,I am trying to calculate difference between two dates from two different rows. I have unique memberid, effective date and end date variables. for some members there are multiple rows. I want to calculate difference between End date and effective date from next row for that member.

thanks

Re: Calculating day span across longitudinal data

data_null__ — Fri, 01 Aug 2014 16:34:46 GMT

Something like this?

data long;
   input id s e;
   informat s e date9.; 
   format s e date9.; 
   cards; 
1 10DEC2012 10FEB2013
1 17DEC2013 19FEB2014
2 10NOV2012 10FEB2013
2 10MAR2013 12APR2013
2 17DEC2013 19FEB2014
;;;;
   run; 
data longnext;
   set long end=eof;
   by id;
   if not eof then set long(firstobs=2 keep=s rename=s=nxs);
   if not last.id then dif = nxs-e;
   run; 
proc print; 
   run;

Re: Calculating day span across longitudinal data

rupalif — Fri, 01 Aug 2014 20:33:17 GMT

It worked! Thank you very much!!!