Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down on April 23, and its replacement, is already up and running.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

st: RE: mysterious missing variables after mydate=mdy(month,day,year)

From   Nick Cox <>
To   "''" <>
Subject   st: RE: mysterious missing variables after mydate=mdy(month,day,year)
Date   Mon, 30 May 2011 18:26:24 +0100

-summarize- automatically ignores missings and trying to include them with an -if- condition makes no difference to that. You need to go 

list month day year if missing(mydate) 


edit month day year if missing(mydate)

to see what is going on. That answers 2) but lacking extra-sensory powers I can not answer 1) very helpfully except to say that something is out of range. 



I have a panel dataset where my date is in different variables (month, day, year), I am able to create a single date variable by mydate=mdy(month,day,year). But the thing is after generating this new variable, stata returns (132 missing values generated). I tried to see where these missing values lie? but to my surprise, I cannot find them; even after 
su  mydate if mydate>=. 
I get zero observations. So, I wonder:

1)what can be the reason of stata returning a missing value while the new variable has no missing values?
2)how can I check the observations that have these missing values.

*   For searches and help try:

© Copyright 1996–2016 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index