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]
Re: st: fillin not filling in -- Stata 12
From
Dorothy Bridges <[email protected]>
To
[email protected]
Subject
Re: st: fillin not filling in -- Stata 12
Date
Sat, 23 Jun 2012 20:42:13 -0700
Right, that's what I understood -- I just had a typo in my query (not
helpful, I know). My understanding is that, in my example, fillin
would give me ten observations for each municipality, or twenty total.
This does not occur in my larger data set. Any thoughts would be
most appreciated.
On Sat, Jun 23, 2012 at 7:41 PM, Steve Samuels <[email protected]> wrote:
>
>
>
> You are mistaken about what -fillin- does. It only creates enough new observations to give you every combination of municipality, year, and month that are *currently* in the data. In your example:
>
> 2 municipalities x 2 years x 5 months = 20
>
>
> Steve
> [email protected]
>
>
> On Jun 23, 2012, at 10:16 PM, Dorothy Bridges wrote:
>
> My data are as follows:
>
> municipality year month
> muni1 1990 1
> muni1 1990 2
> muni1 1991 5
> muni2 1991 6
> muni2 1991 7
>
> According to the documentation and to my prior experience with fillin,
> "fillin municipality year month" should give me 50 observations (ten
> for each municipality -- i.e., muni1 1990 1 / muni1 1990 2 / muni1
> 1990 3 ... muni1 1991 6 muni1 1991 7).
>
> Unfortunately, this does not happen. Some of the desired 50
> observations appear, but many do not.
>
> (Of course, my actual data have close to one million observations, but
> the structure is the same).
>
> The closest archive thread I can find is this one
> http://www.stata.com/statalist/archive/2007-01/msg00891.html, which is
> unresolved (as far as I can tell).
>
> Thanks in advance for your thoughts. I am very confused.
> *
> * For searches and help try:
> * http://www.stata.com/help.cgi?search
> * http://www.stata.com/support/statalist/faq
> * http://www.ats.ucla.edu/stat/stata/
>
>
> *
> * For searches and help try:
> * http://www.stata.com/help.cgi?search
> * http://www.stata.com/support/statalist/faq
> * http://www.ats.ucla.edu/stat/stata/
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/