st: Relative Comparision between Observations

[chaiselongue@gmx.de]

Dear Stata Users,
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.

Best regards and thanks in advance, 

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