Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: RE: Drop observations

From   "Vidya Mahambare" <>
To   <>
Subject   st: RE: Drop observations
Date   Mon, 10 Nov 2003 17:06:33 +0000

Thanks Nick. I will follow your instructions. However, when I try,
 ssc inst tsspell ,
the following error occurs -
checking tsspell consistency and verifying not already installed...
cannot write in directory c:\ado\plus\t

Any solution?


>>> 11/10/03 04:56pm >>>
I assume identifier variable -id-, time variable -t- 
and that you have -tsset- the data. 

For regression it's problematic if either the response
or any of the covariates is missing. Compute 

. egen nmiss = rmiss(y x1 x2 x3) 

One way of doing it then is to use -tsspell- from 

. ssc inst tsspell 
. tsspell, cond(nmiss == 0) 

defines spells for which all variables are present, 
and does so automatically within panels. 

The longest spell in each panel is then 

. egen longest = max(_seq), by(id) 

and you can 

. drop if longest < 4 


Vidya Mahambare

> For panel data regression, I want to include only those 
> firms which have
> observations for at least for four consecutive years out of 
> ten. I suppose I
> have to use drop or keep command, but can't figure out how.

*   For searches and help try:
*   For searches and help try:

© Copyright 1996–2017 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index