Hello dear Statalist,
I am quite new with Stata and I could really need help for my thesis.
I have variables called "cusip" (firm code), "mgrno" (numerical code for investor (unique)), "rdate" (date), "typecode" (classification coding from 1-5 based on investor type), "shares" (number of shares held by each investor in a firm), and shrout2 (total shares for each firm in 1000).
However, some investors report their holdings multiple times a year (as can be seen from below), so if I would try to sum all the shares based on typecode for each firm, many would appear multiple times since they are reported quarterly. Not all however, so how can I do this? If I would like to get the total ownership for each type of investor for every firm for the latest date the ownership has been reported for example.
In the end, I would like to have a database of the ownership % (shares held by each type in each firm/total shares for firm) for each of the 5 investor types for each firm for that year.
Could someone help me?
When I tried dropping rdate duplicates based on mgrno and cusip, I lost necessary observations.
Array
Related Posts with Stata data manipulation filtering, summing and removing duplicates from quarterly observation data
SEM, error coefficients output.Hi, How can I receive the outputs for the "path coefficient" of error terms to each items of a laten…
Gravity model of migration: ppml vs. ppmlhdfeDear all, I'm working on a gravity model of migration for my thesis. My data contains 28 EU countri…
Cox regression assumptionI am doing a research to examine the association between sleep and all-cause mortality. The average …
reshape - wide connectionsI have variables in wide that belong together i groups (eg. var1a and var2a). I would like to reshap…
New Stata 16 versions of dolog, dotex and dologx on SSCThanks as always to Kit Baum, new versions of the dolog, dotex and dologx packages are now available…
Subscribe to:
Post Comments (Atom)
0 Response to Stata data manipulation filtering, summing and removing duplicates from quarterly observation data
Post a Comment