Re: st: observations missing

["Michael Blasnik" <michael.blasnik@verizon.net>]

...

It makes no sense to me that you thought you needed to export data to Excel and 
use filtering to identify missing values in your data.  It is very easy to find 
missing values in Stata and replace them with whatever values you want.  Why 
didn't use just browse if myvar==., or use the egen rowmiss function to identify 
observations with any missing values across a varlist, or use mvencode?  Stata 
is much more powerful than Excel for doing virtually any data management task.

Michael Blasnik



----- Original Message ----- 
From: "Seema Bhatia" <ler02sb@reading.ac.uk>
To: <statalist@hsphsun2.harvard.edu>
Sent: Thursday, September 06, 2007 9:53 AM
Subject: Re: st: observations missing



> Dear Sergiy
>
> Thanks for your comments. Yes the missing observations with their line
> numbers will be very useful. I spend about 30 minutes and 6 regressions
> yesterday before I realised that these 40 missing values were buried inside
> a huge dataset that I have (13650 lines)
>
> I managed to plug in the required values but not before exporting the data
> into excel and turning the filters on which showed me the appropriate
> blanks!
>
> Thanks for the response
>
> Regards
>
> Seema
*
*   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/