Unless I misunderstand the problem, -finddup- can identify the duplicate
and they can be excluded from the interpolation by an if statement
: finddup id panel, keep
Fred Wolfe
At 11:22 AM 4/20/2004, you wrote:
Hello,
I have a panel data set, where there are duplicates of the panel variable.
But I want to retain them because the mistake is only in the panel
variable, not in other variables in the observation. (For my analysis, I
would aggregate the data so that the panel variable is no longer relevant.)
BUT, I keep the panel format in the beginning in order to fill in missing
values using interpolation. To do this I want to keep out observations
with the duplicate panel variable and append them back after interpolation
has been done. For a non-panel data, I could use the stata-code -FINDDUP-
(by Fred Wolfe downloadable from SSC). -finddup- helps to take out a
particular duplicate observation and save it for later use. But it does
not work in a panel set up. Is there any way around, other than doing it
sepeartely for each year?
Joe
_________________________________________________________________
Hotmail on your mobile. Messenger on your mobile.
http://www.msn.co.in/mobile/ Stay connected to what matters.
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
Fred Wolfe
National Data Bank for Rheumatic Diseases
Wichita, Kansas
Tel (316) 263-2125 Fax (316) 263-0761
[email protected]
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/