Bookmark and Share

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/


© Copyright 1996–2018 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index