Re: YNT: st: panel data daily data, missing days, how to fill it up to full months(1-31)

[Nick Cox <njcoxstata@gmail.com>]

It's simple: Statalist is an email discussion list, not a web forum.
If a post was evidently not clear enough to elicit an answer, you need
to post again. There is no editing of previous posts otherwise.

Also: Using nabble doesn't affect how you post to the list. It just
affects what you see if you look at nabble.

Also: Please don't post to individuals. This is explained in the FAQ.

Nick
njcoxstata@gmail.com

On 7 February 2014 11:57, Oben Bayrak <oben.bayrak@slu.se> wrote:

> I have posted the following question, it is still not accepted as a post, Nick cox have suggested me to provide more information about my problem, I will, but I dont know how to update my post, do I have to go the link of my unaccepted post and write the further information as a reply or should i send an email to owner-statalist@....
> Can you please help me with this issue.

> further information that I can provide is the following:
> there are 400 people and measured in daily basis in my data, there is the time variable called 'date' and id variable as 'id' there are also 10 demographic variables that is fixed for each person and those demographics are constant through time.
>
> The desired pattern is to measure the people for a complete month. there are people that are measured full month such as from 1 to 31th of that month. but there are some people that are measured between 1 to 16 or 1-25 or 1-5th of the month. Another property of my data is that the experiment was done between 2005 to 2008. So people were not measured at the same period.  for example, some people recorded between 1th of september 2005 to 26th of september 2005 and some recorded between 5th of november 2006 to 31 december 2006.
>
> What I want is for example for the person who have measured between 1th to 25th november, I want to create rows that have  25th,27th,28th, 29th,30th under the date coloumn and under the id coloumn the id should be same such as 1 for each created day, and i want to copy the demographic variables to that produced rows. but the dependent variable should include na since there is no data for the dependent variable for those days for the given person.
>
> After completing this step I will do multiple imputation to produce those dependent variables.

> ________________________________________
> Kimden: Nick Cox [njcoxstata@gmail.com] adına owner-statalist@hsphsun2.harvard.edu [owner-statalist@hsphsun2.harvard.edu]
> Gönderildi: 06 Şubat 2014 Perşembe 18:27
> Kime: statalist@hsphsun2.harvard.edu
> Konu: Re: st: panel data daily data, missing days, how to fill it up to full months(1-31)
>
> -tsfill- is for adding observations when certain dates have been
> omitted, so are not present in the data. It is not for replacing
> missing values that are present in the data.
>
> You should show us enough of your data to make clear what the missing
> values mean and explain how you expect them to be replaced.

On 6 February 2014 17:14, obba0001 <oben.bayrak@slu.se> wrote:

>> In my panel data, some people have recorded between 1-25 days of the month.
>> some recorded from 3 to 31 days of the month. In addition to this, some of
>> them are not measured for the same month, so in some months which there are
>> 31 days and for some months there are 30 days. what i want is to create
>> those missing days then i will do MI impute, but first i need to make the
>> data ready for imputation.
>> i used tsset to give you more information about my data:
>>
>>  panel variable:  id (unbalanced)
>>         time variable:  day, 18aug2005 to 06jul2008
>>                 delta:  1 day
>>
>> i tried tsfill with the full option but it didnt work.
>> the message i got is:
>> timevar (day) may not contain missing values when option full is specified
>>
>> i looked for that error but didnt understand how to modify the data in order
>> to make this command work. I am a newbie, so i need your help.

*
*   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/