Hi Experts, In my dataset, there are a lot of time series observations for each firm. I would like to keep first 25 observations for each firm. How can I do that?     ... View more

Dear Experts, I need to merge two datasets using the string variable (the name of the of the variable in the attached file is lead_managers_name) and year. Those names are clearly separated in the second dataset named "rank". Please note in the first dataset (named "main_dataset") that many observations have more than one names joined together. In those cases, the variable rank_lead will be the average of those names in that specific year. Let me know if you need more information.   Best regards, Abu ... View more

Dear Experts, I need to match string variables from two different datasets. Datasets look as follows:   Dataset one: Name                            Rank            Year A.S. Goldmen                2.01             2002 A.S. Goldmen                3.01             2003 AG Edwards                  2.51             2001 AG Edwards                  2.61             2002 Credit Suisse                 3.50             2002   Dataset two: Name                                                            Year A.S Goldmen                                                2002 Goldmen (xxx)                                              2003 AG Edwards                                                 2001 AG Edwards                                                 2002   A.S. GoldmenAG Edwards                           2002 Credit Suisse                                                2002 A.S. GoldmenAG EdwardsCredit Suisse     2002   So how will I merge these datasets by Name and Year? The problem is in Name variable in dataset two. Output should be like this: Name                                                                 Rank            Year A.S. Goldmen                                                    2.01             2002 A.S. Goldmen                                                    3.01             2003 AG Edwards                                                      2.51             2001 AG Edwards                                                      2.61             2002 A.S. GoldmenAG Edwards                                2.31            2002 A.S. GoldmenAG EdwardsCredit Suisse          2.7067         2002 For the row A.S. GoldmenAG Edwards, the Rank is average rank of A.S. Goldmen and AG Edwards in 2002 ((2.01+2.61)/2 = 2.31). For the last row (A.S. GoldmenAG EdwardsCredit Suisse), the is average rank of A.S. Goldmen, AG Edwards and Credit Suisse ((2.01+2.61+ 3.50)/3 = 2.7067).   Kind regards, Abu   ... View more