Hello,
I have repeated measures available for several individuals. There are
about 2-4 occassions per individual identified by the date of their
visit. Is there is any function that allows me to extract the first
observation per visit (basically, baseline at each visit).
The only information available in the dataset is (1) ID# (2) DATE (3)
TIME (4) OBS.
I have tried generating occassion number by finding unique date
(?unique) but there are a few individuals visiting on the same date.
So it didn't work.
Example:
ID DATE TIME OBS
1 05/30/2000 7:00 100
1 05/30/2000 9:00 101
1 05/30/2000 11:00 102
1 05/30/2000 13:00 103
1 06/28/2000 8:00 100
1 06/28/2000 10:00 101
1 06/28/2000 12:00 102
1 06/28/2000 15:00 103
2 05/30/2000 7:00 101
2 05/30/2000 9:00 101
2 05/30/2000 10:00 102
2 05/30/2000 12:00 103
I am interested in getting the following information
ID DATE TIME OBS
1 05/30/2000 7:00 100
1 06/28/2000 8:00 100
2 05/30/2000 7:00 101
Any commets are much appreciated.
Thanks.
Pravin
--
Pravin Jadhav
Graduate Student
Department of Pharmaceutics
MCV/Virginia Commonwealth University
DPE1/CDER/OCPB/Food and Drug Administration
Phone: (301) 594-5652
Fax: (301) 480-3212
|