Re: st: Create tables in stata

[Nick Cox <njcoxstata@gmail.com>]

Same advice plus

http://www.stata-journal.com/article.html?article=dm0042 (link leads
to downloadable .pdf).

Nick
njcoxstata@gmail.com


On 21 January 2014 10:00, Torsten Häberle <haeberle.torsten@gmail.com> wrote:
> Sorry Nick! Again:
>
>     Date        Firms        Firm value      Industry Code
> 1 Jan 85
> 2 Jan 85
> 3 Jan 85      FirmX            2                  9304
> 4 Jan 85
> 5 Jan 85      FirmY            4                  2342
> ...
>
> I wanna create the following table:
>
> year    NF     AFV     TFV   NDI    NSI
>
> 1985    2         3           6       2         0
> 1986
> 1987
> 1988
> 1989
>
> NF = Number of Firms in year 1985 (count the "names").
> AFV = Average firm value in 1985 (4+2/2 = 3)
> TFV = Total firm value in 1985 (4+2=6)
> NDI = Number of different Industry Codes (two different industry codes
> in '85 = 2)
> NSI = Number of same Industry Codes in '85 = 0, because they are not the same
>
> 2014/1/21 Nick Cox <njcoxstata@gmail.com>:

>> I think you're assuming some knowledge of business definitions here.
>> This list cuts across people of all disciplines (and of none).
>>
>> Also, if your data value really is "2 Mio." that can only be a string
>> value, and you will have a hard time summarizing the corresponding
>> variable numerically.
>>
>> Broadly, the easiest way to approach this by thinking that you will
>> get some of the way by a -collapse, by(year)-. But some of the columns
>> in your table will have to be created before you -collapse-.

>> Nick
>> njcoxstata@gmail.com
>>
>>
>> On 21 January 2014 09:35, Torsten Häberle <haeberle.torsten@gmail.com> wrote:
>>> 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?

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