I have a similar problem to Robert's in that I know for sure there are
missing data for a particular variable ('canter') but if I type
tab canter if canter==.
I am told there are 'no observations'
canter is stored as float but following Neil's suggestion still gives me 'no
observations'. Please can anyone tell me how I find out exactly how many
missing values there are?
Thank you,
Kristien Verheyen
PhD student
Date: Wed, 8 Oct 2003 16:10:42 +0100
From: "Neil Shephard" <[email protected]>
Subject: Re: st: bizarre missing observations
> I am having problem with a variable (refdate) It is a continuous
> measure of the date of first college enrollment. The coding scheme is
>YEAR.PROPORTION OF YEAR. For example 1992.5 means that the student
> enrolled in college in June of 1992, 1992.58 means the student
> enrolled in college in July of 1992, 1992.67 means the student
> enrolled in college in August of 1992, and so forth.
>
> When I have STATA run a frequency distribution (tab refdate), it tells
> me that I have 6,268 observations who enrolled in 1992.67
>
> However, when I run the command:
> tab refdate if refdate == 1992.67
> STATA tells me that there are 'no observations'
>
> How could that be if in the frequency distribution there are 6,268
> cases?
>
This sounds like something I've been bitten by before.
Check the storage type of refdate....
des refdate
Its most probably stored as a float, in which case you need to use
the float function when evaluating your expression, so
tab refdate if refdate == float(1992.67)
should do it.
HTH
Neil
Neil Shephard
Genetics Statistician
ARC Epidemiology Unit, University of Manchester
[email protected]
[email protected]
"Contrariwise, if it was so, it might be; and if it
were so it would be; but as it isn't, it ain't. That's
logic" - Tweedledee (Alice Through the Looking Glass)
*
* 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/
------------------------------
**********************************************
Visit our website at www.aht.org.uk
**********************************************
#####################################################################################
This e-mail message has been scanned for Viruses and Content and cleared
by MailMarshal
For more information please visit www.marshalsoftware.com
#####################################################################################
*
* 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/