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: Assign fiscal year-end values to a specific event in time


From   Nick Cox <[email protected]>
To   "[email protected]" <[email protected]>
Subject   Re: st: Assign fiscal year-end values to a specific event in time
Date   Tue, 28 Jan 2014 16:16:11 +0000

How are you Miriam Geiringer? Statalist is clear that you should use
your full real name in posting.

This is yet further evidence that you are not respecting our protocol
and etiquette. Compare
http://www.stata.com/statalist/archive/2014-01/msg00961.html

Nick
[email protected]


On 28 January 2014 14:47, Torsten Häberle <[email protected]> wrote:
> Hi Nick,
>
> thanks for your answer. It's not an interpolation problem. I just want
> to assign either the last available fiscal year-end value (before the
> event) or the first available fiscal year-end value (after the event)
> to the event date.
>
> But as you said, Stata keeps on going until it reaches the next
> non-missing. But this is wrong in my case. Values are only valid in
> this time window:
> - Either 12 months before the event (as in dataset 1) or
> - 12 months after the event (as in dataset 2)
>
> But Stata should not copy a value further in the future if let's say
> the next fiscal year-end value is missing.
>
> I just need an approximate value on event date. For dataset 1, this is
> a value from the previous 12 months. For dataset 2, it is one from the
> following 12 months.
>
> Do you know what I mean?
>
> Thanks for helping
>
>
> 2014-01-28 Nick Cox <[email protected]>:
>> Yes; if you copy previous values to replace missing values, Stata
>> keeps on going until it reaches the next non-missing.
>>
>> But what are you trying to do here? Like many others, your problem
>> seems more of an interpolation problem, and  copying the last known
>> value is not necessarily the best way forward. See
>>
>> http://www.stata.com/statalist/archive/2014-01/msg00315.html
>>
>> for some general comments and mentions of Stata commands for interpolation.
>>
>> Nick
>> [email protected]
>>
>> On 27 January 2014 21:36, miriam geringer <[email protected]> wrote:
>>
>>> In terms of my example:
>>>
>>> Company   Date      Year     Price      Event    Month*
>>> A                 31Okt    1988                               334
>>> A                 29Nov    1988    10                      335
>>> A                 31Dez    1988                              336
>>> A                 31Jan     1989                              337
>>> A                 14Feb     1989               EventX   338
>>> A                 28Feb     1989                              339
>>> A                 31Mar     1989                              340
>>> B
>>> B
>>> ....
>>>
>>> *Month = Numerical date variable, monthly frequency. Stata command = mofd(Date)
>>>
>>> This is my command: bysort Company (Month): replace Price =
>>> Price[_n-1] if missing(Price)
>>>
>>>>>> then 10 is spread forward until the next fiscal year-end value is available
>>>>>> Basically, the price indicates that the fiscal year ends. In our case, on 29Nov 1988, there is a price available. This means the fiscal year ends here. And this price shall now be spread forward until the next fiscal year-end arrives.
>>>>>> What I wonder now: What happens if the next fiscal year-end value (in our example 1989) is now missing?
>>>
>>> Example:
>>>
>>> Company   Date      Year     Price      Event    Month*
>>> A                 31Okt    1988                               334
>>> A                 29Nov    1988    10                      335
>>> A                 31Dez    1988    10                      336
>>> A                 31Jan     1989    10                      337
>>> A                 14Feb     1989    10        EventX  338
>>> A                 28Feb     1989    10                      339
>>> A                 31Mar     1989    10                      340
>>> A                 30Apr      1989    10
>>> A                 31May     1989    10
>>> A                 30Jun      1989     10
>>> A                 31Jul        1989    10
>>> A                 31Aug      1989     10
>>> A                 30Sep      1989     10
>>> A                 31Okt       1989     .
>>>
>>> If the price on 31 Okt 1989 (the fiscal year-end) is missing, Stata
>>> should NOT replace the missing value with the price (10) from the
>>> previous fiscal year 1988. Instead, it should remain missing. But I
>>> think my command doesn't consider this?
>>
>>  2014-01-26 Nick Cox <[email protected]>:
>>
>>>> That does not help me in terms of your example or explanation.
>>>>
>>>> A strategy is to "spread" values to other observations for the same
>>>> firm and then look for intersections. My Stata Journal article just
>>>> cited gives examples.
>>
>> On 26 January 2014 11:51, miriam geringer <[email protected]> wrote:
>>
>>>>> I have two variables, which tell me when the fiscal year ends.
>>>>> An exact variable, e.g. 31Jul 1994 and a year variable, e.g. 1994.
>>
>> 2014-01-26 Nick Cox <[email protected]>:
>>
>>>>>> How can you tell Stata in terms of these data when fiscal years end?
>>>>>>
>>>>>> What kind of variable is -Date- (numeric or string)? Are you using
>>>>>> Stata dates (see -help dates and times-)?
>>>>>>
>>>>>> There is much discussion of technique in
>>>>>> http://www.stata-journal.com/article.html?article=dm0055
>>
>> On 25 January 2014 19:19, miriam geringer <[email protected]> wrote:
>>
>>>>>>> I have the following two datasets:
>>>>>>>
>>>>>>> 1)
>>>>>>>
>>>>>>> Company   Date      Year     Price      Event
>>>>>>> A                 31Okt    1988
>>>>>>> A                 29Nov    1988    10
>>>>>>> A                 31Dez    1988
>>>>>>> A                 31Jan     1989
>>>>>>> A                 14Feb     1989                EventX
>>>>>>> A                 28Feb     1989
>>>>>>> A                 31Mar     1989
>>>>>>> B
>>>>>>> B
>>>>>>> ....
>>>>>>>
>>>>>>> Basically, there is some event going on in 1989. This event can happen
>>>>>>> in every month, on every day. I want to assign a specific value from
>>>>>>> the previous fiscal-year to the event in 1989. To be more precise, I
>>>>>>> want to assign the fiscal year-end price from fiscal year 1988 to the
>>>>>>> event which happens - in our example - on 14Feb 1989. In the end, I
>>>>>>> only need to know in what year the event happened and the
>>>>>>> corresponding price from the previous fiscal year-end. Sometimes,
>>>>>>> there is no price available in the previous fiscal year, then it
>>>>>>> should be just marked as missing value.
>>>>>>>
>>>>>>> ---- Fiscal Year-End 1988 ------- Event -------- Fiscal Year-End 1889
>>>>>>>>>>>> Assign Fiscal Year-End 1988 to Event
>>>>>>>
>>>>>>> The fiscal year can end in every month and it is possible that, for
>>>>>>> example, the fiscal year ends on 31Jan 1989 and the event occurs on
>>>>>>> 14Feb 1989. Then the 31Jan 1989 value shall be assigned.
>>>>>>>
>>>>>>> It should be something like:
>>>>>>> If Stata finds an EventX in fiscal year 1989 of Company A, go to
>>>>>>> fiscal year 1988 and take the 1988 fiscal year-end price of Company A
>>>>>>> and assign it to the EventX in 1989.
>>>>>>>
>>>>>>> 2) The second dataset is identical. However, this time I want to
>>>>>>> assign the first available fiscal year-end value.
>>>>>>>
>>>>>>> Company   Date      Year     Price      Event
>>>>>>> A                 31Okt    1988
>>>>>>> A                 29Nov    1988
>>>>>>> A                 31Dez    1988
>>>>>>> A                 31Jan     1989
>>>>>>> A                 14Feb     1989               EventY
>>>>>>> A                 28Feb     1989
>>>>>>> A                 31Mar     1989    10
>>>>>>> B
>>>>>>> B
>>>>>>> ....
>>>>>>>
>>>>>>> In this example, let's assume the year ends on 31Mar 1989 and on that
>>>>>>> date, the price is 10 (the fiscal year-end price). I want to assign
>>>>>>> this price to the row with the EventY and 14Feb. The same as in
>>>>>>> dataset 1, just the other way around.
>>>>>>>
>>>>>>> It should be something like:
>>>>>>> If Stata finds an EventY in year 1989 of Company A, take the first
>>>>>>> available fiscal year-end value (first one available after the event
>>>>>>> occured). The event can occur in February and the fiscal year can
>>>>>>> could end shortly after. Just take the next available value, no matter
>>>>>>> whether there is a calendar year shift in between or not.

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


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