Removing duplicates in panel data

[paues]

I have a work file with a undated panel (see attached example). Unfortunately it contains quite a few duplicates. How would I remove the superfluous entries?

[EViews Gareth]

How are you defining a duplicate?

[paues]

Two observations with identical values for all variables.

[EViews Gareth]

Can't think of an easy way to do it. This might get you most of the way there:

Code: Select all

pagecontract if country<>country(-1) or flow<>flow(-1) or value<>value(-1) or year<>year(-1) or @trend=0

Make sure you have a backup before trying it though!

[paues]

If preceded by

Code: Select all

sort country flow value year

your code should settle it, don't you think?

[EViews Gareth]

probably.