Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
st: recording the first/last non-missing/missing values position
From
Qunzi Zhang <[email protected]>
To
[email protected]
Subject
st: recording the first/last non-missing/missing values position
Date
Sun, 4 Nov 2012 20:14:21 +0100
Dear All,
I have a dataset as below
date firm 1 firm2 firm3 .....(permno as identifer index for firm)
1970Jan01 1 2 nan
1970Jan02 1 2 nan
..........................................
1990Jan01 1 2 4
1990Jan02 1 2 4
.........................................
1990Jan01 1 nan nan
1990Jan02 1 nan nan
I would like to store the time/row index for the first(last) nan value and
the first(last) non-nan value in this data set. Can anyone give me an
example about how to do this in the do file?
Thanks
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/faqs/resources/statalist-faq/
* http://www.ats.ucla.edu/stat/stata/