Hello All, I would highly appreciate if someone tell me how I can sum up the firms in an industry and then take the inverse of the sum. My data looks as follows: firm year industry A     2001     OIL B     2001     OIL C     2001     OIL D     2001     OIL A     2002     OIL B     2002     OIL C     2002     OIL U     2001     SERVICE V     2001    SERVICE W     2001     SERVICE X    2001     SERVICE Y     2002     SERVICE U     2002     SERVICE Z     2002     SERVICE I want the output to look like firm year industry               SUM     invese A     2001     OIL                 4          1/4 =0.25 B     2001     OIL               4          0.25 C     2001     OIL               4          0.25 D     2001     OIL               4          0.25 A     2002     OIL               4          0.25 B     2002     OIL               4          0.25 C     2002     OIL               4          0.25 U     2001     SERVICE     6          0.17 V     2001    SERVICE     6          0.17 W     2001     SERVICE     6          0.17 X    2001     SERVICE     6          0.17 Y     2002     SERVICE     6          0.17 U     2002     SERVICE     6          0.17 Z     2002     SERVICE     6          0.17      Thank you. ... View more

Hello Everyone, I have a set of firms which I divided into three categories- 1, 2, and 3- based on their special characteristics. For each category, I have some information like sales, profit, and so on. I want to test the difference in proportion for this sample. In other words, I want to test whether the total sales in Group 1 is significantly different from Group 2 and 3. The data I have is as follows: Group sales profit 1          100     20 2          150     10 3          120     40 I would appreciate if someone shares the code that will help me do the desired analysis. Thank you. ... View more

Hello Everyone, I have two datasets Y1 and Y2. Both the data has a list of firms. Some of the firms in Y2 are also in Y1. I want to create a new dataset Y3 from Y2 that does not includes any firms present in Y1. data y1; input firm $; cards; 2000     A    2000     B     2001     A     2002     A     2002     C    2002     D    ; RUN; data y2; input year firm $ ; cards; 2000    a     2000    c      2000     o    2000     p    2001     q    2001     r    2002     s    2002     t    2002     c    2002      v   2002     w    2002     x     ; RUN; Desired output (data y3) year firm    2000     o    2000     p     2001     q    2001     r     2002     s     2002     t    2002      v    2002     w     2002     x    Thank you. ... View more

I have two samples of firm- test sample and control sample. I want to find a match for my test sample from the control sample from the same industry. I also want to make sure that if there are two firms in my test sample from same industry, then I need two distinct firms from control sample for matching. For instance my test sample looks like this: data sample; year firm $ industry; cards; 2000     A     21 2000           B           21 2001     A     21 2002     A     21 2002     C     50 2002     D     60 ; RUN; The Control sample looks like the following:      data control; year firm $ industry; cards; 2000    m      21 2000          n               21 2000     o     21 2000     p     21 2001     q     21 2001     r     21 2002     s     21 2002     t     21 2002     u     21 2002      v    50 2002     w     50 2002     x     60 ; RUN; The final sample (match) should look like: year  sample  industry     control   2000     A     21           m 2000           B           21                        n 2001     A     21           q 2002     A     21           s 2002     C     50           v 2002     D     60           x Thank you in advance. ... View more

I have the following data and I need to create a variable HHI which is the sum of the market share of four largest firms in each industry. INDUSTRY     YEAR     FIRM     SALES 1                    2001          A          100 1                    2001          B          200 1                    2001          C          150 1                    2001          D          50 1                    2001          E          100 1                    2001          F         400 1                    2002          A          100 1                    2002          B          130 1                    2002          C          170 1                    2002          D          190 1                    2002         E          108 1                    2002          F         100 2                    2001          S          150 2                    2001        T            250 2                    2001          U          570 2                    2001          V         550 2                    2001         W         750 2                    2001         X          560 2                    2001          Y          450 I want to have a data set that looks like this: INDUSTRY YEAR     FIRM     SALES    sum_industry_sales     large4sales  market share            weight (market share*market share)      HHI 1                2001          A          50      1000                              .                     .                         .                             0.04+0.0225+0.0225+0.16=0.245 1                2001          B          200     1000                         200                 200/1000= 0.2                0.04                                      0.245 1                2001          C          150     1000                         150                 0.15                              0.0225                                    0.245 1                2001          D          50       1000                             .                  .                                     .                                         0.245 1                2001          E          150      1000                         150                 0.15                               0.0225                                   0.245 1                2001          F         400       1000                         400                 0.4                                0.16                                     0.245 1                2002          A          100     798                         .                        .                                           .                                       0.15 1                2002          B          130     798                         130                    0.16                                   0.03                                    0.15 1                2002          C          170     798                         170                    0.21                                   0.04                                     0.15 1                2002          D          190     798                         190                    0.24                                  0.06                                     0.15 1                2002         E          108      798                          108                   0.14                                   0.02                                    0.15 1                2002          F         100      798                             .                      .                                    .                                            0.15 2                2001          S          150     3280                          .                      .                                    .                                            0.14 2                2001        T            250      3280                          .                      .                                  .                                               0.14 2                2001          U          570      3280                          570                 0.17                           0.03                                          0.14 2                2001          V         550       3280                          550                 0.16                           0.03                                         0.14 2                2001         W         750       3280                          750                0.22                           0.05                                          0.14 2                2001         X          560       3280                          560                 0. 17                          0.03                                          0.14 2                2001          Y          450      3280                          .                     .                                      .                                           0.14 ... View more

Hi Everyone, I need help with the construction of a variable, 4firm_ratio. 4firm_ratio is calculated as the market share of largest four firms within each industry.  For example., in an industry if there are 10 firms, I need to select the largest four firms. Let's say the largest four firms are ABC, MNO, STU, and XYZ. I need to calculate the market share for each of these firms. Market share of firm ABC is calculated as  square of SALE of ABC divide by total industry SALES. After calculating the market share of the largest four firms in an industry, I need to add the market share of ABC, MNO, STU, and XYZ. The addition will be called as 4firm_ratio. ... View more