Re: st: Missing Values

[Sadia Khalid <sadiakhalid234@gmail.com>]

Thanks a lot for your help

Regards
Sadia

On 8 January 2014 15:45, Nick Cox <njcoxstata@gmail.com> wrote:
> I'm confused. There are posts appearing from
>
> Sadia Khalid
>
> and
>
> Muhammad Ramzan
>
> 1. If you are one person using two email addresses, please don't do
> that. Statalist has a strong principle that people use their full real
> names. Using someone else's name violates that.
>
> 2. If you are two people looking at the same problem, please make that clear.
>
> Use a -foreach- loop to loop over a set of variables.
>
> Nick
> njcoxstata@gmail.com
>
>
> On 8 January 2014 10:36, Muhammad Ramzan <ramzan243@gmail.com> wrote:
>> Thanks a lot
>>
>> Nick Cox
>>
>> If i want to run this command for all the variables in the data set.
>> any code for this.
>>
>>
>> On 8 January 2014 02:19, Nick Cox <njcoxstata@gmail.com> wrote:
>>> <>
>>>
>>> If that really is the error message, you are typing
>>>
>>> seq
>>>
>>> where you mean
>>>
>>> _seq
>>>
>>> i.e. you are not typing the command you need.
>>>
>>> Nick
>>> njcoxstata@gmail.com
>>>
>>> On 8 January 2014 03:16, Sadia Khalid <sadiakhalid234@gmail.com> wrote:
>>>
>>>> Thanks a lot for the reply
>>>>
>>>> I am getting an error for this command
>>>>
>>>> egen max = max(_seq), by(company _spell)
>>>>
>>>> The error message is "seq not found"
>>>>
>>>> Please look at this issue.
>>>
>>> On 7 January 2014 23:22, Nick Cox <njcoxstata@gmail.com> wrote:
>>>
>>>>> That's not what you said, but it makes more sense. Here is some technique:
>>>>>
>>>>> First, you show no data, so we need a sandpit to play in:
>>>>>
>>>>> webuse grunfeld, clear
>>>>> set seed 2803
>>>>> replace invest = . if runiform() < 0.7
>>>>>
>>>>> Download -tsspell- from SSC and then identify spells of missing values:
>>>>>
>>>>> tsspell , c(missing(invest))
>>>>>
>>>>> The length of each spell is an easy calculation
>>>>>
>>>>> egen max = max(_seq), by(company _spell)
>>>>>
>>>>> Then any interpolation is made conditional:
>>>>>
>>>>> by company: ipolate invest year if max <= 5, gen(invest2)
>>>>>
>>>>> For explanation of the _principles_ of identifying spells, see
>>>>>
>>>>> SJ-7-2  dm0029  . . . . . . . . . . . . . . Speaking Stata: Identifying spells
>>>>>         . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  N. J. Cox
>>>>>         Q2/07   SJ 7(2):249--265                                 (no commands)
>>>>>         shows how to handle spells with complete control over
>>>>>         spell specification
>>>>>
>>>>> http://www.stata-journal.com/sjpdf.html?articlenum=dm0029
>>>
>>> On 7 January 2014 17:37, Sadia Khalid <sadiakhalid234@gmail.com> wrote:
>>>
>>>>>> I only want to fill in the missing values if the no of missing values
>>>>>> are equal to or less than 5. if 5 or more values are missing than do
>>>>>> not fill in the missing values.
>>>
>>> On 7 January 2014 22:31, Nick Cox <njcoxstata@gmail.com> wrote:
>>>
>>>>>>> So 5 is OK for interpolation, but 4 or 6 isn't? Sounds bizarre.
>>>
>>> On 7 January 2014 17:22, Sadia Khalid <sadiakhalid234@gmail.com> wrote:
>>>
>>>>>>>> I have read about your code for filling the in between missing values
>>>>>>>> at http://www.stata.com/statalist/archive/2003-05/msg00247.html
>>>>>>>>
>>>>>>>> I want the code that fill the missing values only if 5 inbetween
>>>>>>>> values are missing.
>>> *
>>> *   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/
>>
>>
>>
>> --
>> Assalam-o-Alaikum
>>
>>
>>
>>
>>
>>
>>
>> Muhammad Ramzan
>> Lecturer (Economics)
>> Pakistan Institute of Development Economics
>> Islamabad
>> *
>> *   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/
> *
> *   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/
*
*   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/