Scott,
I have some questions about your data and the assumptions you make.
1. What is the meaning of the duplicate observations for firms A and
B? Are they repeated because there are two investors in the same
stage? If so, why are there no duplicate (or rather triplicate)
observations for firm D?
2. You write that firm C receives financing only from one investor.
How do you know that the financing comes from the same investor in
all three stages? Or do you define "financing from one investor" as
"financing from only one investor at any given stage"? Why do the
three stages all begin on the same date, 1 Feb 01? Why do the two
stages listed for firm D both begin on 15 May 95?
3. How do you measure the periods of financing? How do you know that
the investment firm A received on 1 Oct 96 ended half a year later,
on 1 Apr 97? How do you know that firms B and D received financing
for exactly one year and not just for three months or two years?
As a final comment, it looks like you constructed your tables with a
proportional font. The columns don't line up properly when viewed
with a fixed-width font. You may want to read this article that
describes how to use Gmail with a fixed-width font:
http://huebler.info/2005/20051003_statalist.html
Friedrich
--- Scott Hill <[email protected]> wrote:
> I would like to ask for your help. I have a dataset which has the
> following format.
>
>
> Firm Stage Stage Number Stage
> Name Number of Investors Date
> A 1 1 1 Oct 96
> A 2 2 1 Apr 97
> A 2 2 1 Apr 97
> B 1 2 28 Mar 01
> B 1 2 28 Mar 01
> C 1 1 1 Feb 01
> C 2 1 1 Feb 01
> C 3 1 1 Feb 01
> D 1 3 15 May 95
> D 2 3 15 May 95
>
> In this example, there are 4 firms, A, B, C, and D. These are firms
> which receive financing from investors in various stages and dates.
> Firms A, B, and D received financing from several investors, while
> firm C received financing only from 1
> investor.
>
>
> So firm A received financing in the 1st stage (column Stage_Number)
> from 1
> investor (column Stage_Number_of Investors) on 1 Oct 96 (column
> Stage_Date). In
> the 2nd stage, firm A received financing from 2 investors on 1 Apr
> 97.
>
> I would like to summarize the number of firms which received
> financing from
> several investors like this:
>
> In terms of stages:
>
> Stage No. of Firms Which Received Financing From
> Number Several Investors
> 1 2 (referring to firms B and D)
> 2 1 (referring to firm A)
> Total: 3 firms
>
> In terms of years:
>
> Year(s) No. of Firms Which Received Financing
> From Several Investors
>
>
> 0.5 1 (referring to firm A - 1 Oct 96 to a Apr 97)
> 1 2 (referring to firms B and D)
> Total: 3 firms
>
> I tried to find ways to summarize this kind of information in
> Stata, but was
> unsuccessful. Could somebody help me?
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
