| 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
>
>
>
|
