st: Create tables in stata

[Torsten Häberle <haeberle.torsten@gmail.com>]

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/