Date:         Mon, 19 Apr 2004 16:55:11 -0400
Reply-To:     Liping Huang <LHuang@VNSNY.ORG>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Liping Huang <LHuang@VNSNY.ORG>
Subject:      summarizing data by case and each consecutive period
Content-Type: text/plain; charset="iso-8859-1"

> I have the following data set that is shown bellow.
>
> case  visit date      visit
> 1001  01jan2002       1
> 1001  02jan2002       1
> 1001  03jan2002       1
> 1001  04jan2002       .
> 1001  05jan2002       .
> 1001  06jan2002       1
> 1001  07jan2002       1
> 1002  01mar2002       1
> 1002  02mar2002       1
> 1002  03mar2002       .
> 1002  04mar2002       .
> 1002  05mar2002       .
> 1002  06mar2002       1
>
> What I would like to do is to sum up total number of visits for a
> consequctive days by case and each consecutive period.
>
> case  visit date      visit_end       visit
> 1001  01jan2002       03jan2002       3
> 1001  06jan2002       07jan2002       2
> 1002  01mar2002       02mar2002       2
> 1002  06mar2002       06mar2002       1
>
> Anyone has idea about how to do it?
>
> Thanks in advance.
>
> Liping
>
>
>