Michael got some good answers to this. However, there is
a shorter answer to his question:
list if missing(real(number))
or
edit if missing(real(number))
shows the records (Stataspeak: observations) without the
intermediary of any other command or any new variable.
For
missing(real(number))
read
real(number) >= .
according to taste.
Nick
[email protected]
Michael McCulloch
I've got a field that's supposed to be all numbers but due to keying
errors may contain letters. How can I find those records?
What I've done:
. destring number, replace
Error message:
number contains non-numeric characters; no replace
*
* 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/