st: Need Help regarding sorting

[Michael Stewart <michaelstewartresearch@gmail.com>]

Hi
I am working on a  health care  database and  am trying to weed out duplicates

My data  is as follows

Patientname   date_of_event type
xxxx   1/1/2010   HP
xxxx   1/2//2010 DS
xxxx   1/3/2010 DS
xxxx  1/5/2010  HP
xxxx  1/6//2010  DS
yyyy   1/4/2011  HP
yyyy  1/5/2011 DS

Here in this dataset DS refers to discharge summary and HP refers to
history and physical

I am specifically trying to find out for each patient: if  two DS are
separated by a HP

Thanks a lot
MIke



-- 
Thank you ,
Yours Sincerely,
Mike.
*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/faqs/resources/statalist-faq/
*   http://www.ats.ucla.edu/stat/stata/