Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

Re: st: finding non-numeric characters before I can destring


From   n j cox <[email protected]>
To   [email protected]
Subject   Re: st: finding non-numeric characters before I can destring
Date   Fri, 19 Oct 2007 17:24:02 +0100

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/



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