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: Relative Comparision between Observations
From
"Jens Kruk" <[email protected]>
To
[email protected]
Subject
Re: st: Relative Comparision between Observations
Date
Thu, 25 Aug 2011 15:55:07 +0200
Hi Nick,
lets say the data looks like this:
id____isspread____start____end____transaction
1_____1___________3________6______.
2_____0___________.________.______5
3_____1___________2________5______.
4_____0___________.________.______5.5
now what I want Stata to do is to tell me (for example by creating additional variables that contain the ids) that ids 2 and 4 occured between start and end date of observation 1 (5 and 5.5 are between 3 and 6) and that id 2 occured between the start and end date of spread 3 (5 is weakly between 2 and 5).
A perfect result of the procedure would look like this:
id____isspread____start____end____transaction____tr1___tr2
1_____1___________3________6______.______________2_____4__
2_____0___________.________.______5______________._____.__
3_____1___________2________5______.______________2_____.__
4_____0___________.________.______5.5____________._____.__
Best, Jens
-------- Original-Nachricht --------
> Datum: Thu, 25 Aug 2011 14:22:19 +0100
> Von: Nick Cox <[email protected]>
> An: [email protected]
> Betreff: Re: st: Relative Comparision between Observations
> Please show a representative chunk of your data so that precisely what
> are your variables and your observations becomes clear.
>
> Nick
>
> On Thu, Aug 25, 2011 at 2:09 PM, <[email protected]> wrote:
>
> > I want to perform the following task for a very large dataset (so
> writing a Mata loop is probably not the solution): the dataset consists of two
> sorts of data: spreads and transactions. Spreads do have a start and an end
> date, while transactions only have a transaction date. Now I want to know
> whether some transaction happend between the start and end date of a spread.
> Ideally, I would like to have variables containing all the ids of
> transactions that occured between the start and end data of the spread for each
> spread. Is there a way to use inexact matching or merging for this ?
> > This should be a familiar problem, however, I do not have a clue how to
> solve it.
>
> *
> * 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/
--
NEU: FreePhone - 0ct/min Handyspartarif mit Geld-zurück-Garantie!
Jetzt informieren: http://www.gmx.net/de/go/freephone
*
* 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/