Query: using lag(id) ....

["susan charman" <charmansusan@hotmail.com>]

Dear s-newsers

 

I should be grateful for suggestions on how to do the following:

 

I have a few thousand patient records. I wish to search for duplicate records and for those which are duplicates , make some checks and delete if necessary (certain types of dulpicated allowed).

 

I really do not want to use a loop so I thought I could sort by id and then create vector lag(id) and compare it with id. However, lag() creates a vector of the same length but numbers position 0 to n-1 as opposed to 1 to n.

 

Does anyone have a better more efficient method?

 

Very many thnaks

 

Susan

---

Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.