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 21:19:27 -0700
Never mind -- I am indeed confused -- my apologies.
On Sat, Jun 23, 2012 at 8:42 PM, Dorothy Bridges <[email protected]> wrote:
> 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/