Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down at the end of May, and its replacement, statalist.org is already up and running.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: st: Obtain information from nearest observation


From   Chamara Anuranga <kcanuranga@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: Obtain information from nearest observation
Date   Fri, 7 Sep 2012 22:22:59 +0530

Hi,

Append two data set. put date variables together. sort by company and
date. Then fill the blank for net sales variable taking previous
value.
replace net_sales=net_sates[_n-1] if net_sales==.
keep the dataset if event_date not missing.

Hope this help. If you need more information please add sample data.

Thanks
Chamara

On Fri, Sep 7, 2012 at 9:24 PM, "Marco Müller" <endlevel@gmx.ch> wrote:
> Hi all
>
> I have the following problem: I have a dataset A with event dates for
> firms as:
> COMPANY    EVENT_DATE
> 1          01/03/1986
> 2          15/08/2001
>
>
> and I have a dataset B with financial information about the firms, e.g.:
> COMPANY     DATE             NET_SALES
> 1           31/12/1985       1'000
> 1           31/12/1986       2'000
> 1           31/12/1987       1'200
> ....
> 2           30/06/2000         400
> 2           30/06/2001         600
> 2           30/06/2002         700
>
> I'd like to obtain the last available net sales information PRIOR to the
> event date (or, in another case, the first one FOLLOWING the event date).
> For example, I'd like to obtain the net sales of 1'000 and 600 for A and B
> (prior to the events) and 2'000&700 following the events.
>
> Any suggenstions how to handle that?
>
> Many thanks for your suggestions
>
> Best regards,
> Marco
> *
> *   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–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index