Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
| From | Torsten Häberle <haeberle.torsten@gmail.com> |
| To | statalist@hsphsun2.harvard.edu |
| 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 <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/
*
* 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/