[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]
st: A query on handling monthly data
Dear Statalist users and experts,
My dataset consists of monthly data of about 12000 households for 10
years, some of which are repeating and others are not. Data for all
months is not available, ie, for many months, there is no observation.
On an average, each year has data for 4 months. Though it's understood
that values are zero for non-reported months, I have't created extra
observations and filled-in zeros. Thus the monthly data is not in
regular intervals,i.e., this is with gaps.
Now, I need to do the following things with my dataset:
1. Create a timeid for each month, which is of stata-compatible form,
say, 1994m1,.... I have a variable for year and one for month, both
2. Do tsset and then define a variable that takes, throughout, the
value of the first observation of each cross-section of an existing
variable. This observation-number is not the same for most
cross-sections, as data for different crosssections may start in
Though both of these problems seemed trivial to me before, I could not
do much and hence I really need your help to proceed further, atleast
for the problem 1.
Thanking you in anticipation.
Badri Narayanan G.,
* For searches and help try: