Summary of Variables by category

[Guest]

Hello everybody,

I need your help. I would like to generate a summary of all companies. The companies are categorized (Large=Dummy Variable 1 and SME=Dummy Variable 0).
The summary should show the number of all companies by category and GICS Sector. Example: In GICS sector 20 the number of large firms is 2 and SME 0.

Thanks for your help!

Observation | Company-Name | Category | GICS Sector
1                Test A            1             10
2                Test B            0             45            
3                Test C            1             20
4                Test D            1             20

[Nick Cox]

tab GICS category

may help.

[Guest]

Thanks for the help!

If I have now observations over several years (so one company can occur several times), how can the total number of each company per GICS and category be displayed?
Is it possible to export this table, where instead of 1 and 0, then Large Company and SME is displayed?

[Nick Cox]

Please give a realistic data example and show what kind of output you seek. The specification "this table" is ambiguous; do you want year to be part of the tabulation or to count each company just once, or what? What happens if a company changes category?

See https://www.statalist.org/forums/help#stata on how to give a data example.

[Guest]

Okay, sorry it was a little vague. Basically, I am looking for a function that displays a plot like this. Here all observations are shown. But it should only count each company per GICS.

It would be great if there is a possibility to export this table (Excel/Word). Instead of the 0 and 1, then family companies and non-family companies.

I hope it was understandable. Thanks a lot for the help!

 tab gsector Family_Firm

       GIC |      Family_Firm
   Sectors |         0          1 |     Total
-----------+----------------------+----------
        10 |        37          1 |        38 
        15 |        33         10 |        43 
        20 |        78          8 |        86 
        25 |        41         72 |       113 
        30 |        23          5 |        28 
        35 |       185         21 |       206 
        40 |        47         26 |        73 
        45 |       353        202 |       555 
        50 |        60         73 |       133 
        55 |        31          1 |        32 
        60 |         3          5 |         8 
-----------+----------------------+----------
     Total |       891        424 |     1,315