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: Create tables in stata


From   Torsten Häberle <[email protected]>
To   [email protected]
Subject   Re: st: Create tables in stata
Date   Tue, 21 Jan 2014 10:35:22 +0100

Sorry, the table is bad. Again:

DailyDate     IPO            Offering value      SIC Code
1 Jan 85
2 Jan 85
3 Jan 85      Firm X          2 Mio.                   9304
4 Jan 85
5 Jan 85      Firm Y          4 Mio.                    2342
...

I wanna create the following table:

year  No. of IPOs     Average           Total           No. of diff.   No. of
                              offering value offering value    SIC
    same SIC
1985    2 (X&Y)           3 Mio.            6 Mio.              2
          0
1986
1987
1988
1989
        Count firm names
       (One name=One IPO)


2014/1/21 Torsten Häberle <[email protected]>:
> Hey guys,
>
> I am about to create my first table in Stata. Would appreciate some
> starting help!
> I have daily data and want to create a table that kind of summarizes
> the data by year. It looks like this:
>
> DailyDate     IPO            Offering value      SIC Code
> 1 Jan 85
> 2 Jan 85
> 3 Jan 85      Firm X          2 Mio.                   9304
> 4 Jan 85
> 5 Jan 85      Firm Y          4 Mio.                    2342
> ...
>
> I wanna create the following table:
>
> year          Number of IPOs          Average             Total
>          No. of different     No. of
>                                                   offering value
> offering value            SIC                same SIC
> 1985                  2 (X&Y)                   3 Mio.              6
> Mio.                        2                   0
> 1986
> 1987
> 1988
> 1989
>                   Count firm names
>                   (One name=One IPO)
>
> Can someone give me some input?
>
> Thanks
> *
> *   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/

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