Hi, I am using the following data (Sample). I need to create a panel id which is uniquely identified. I have three trade groups and in every trade group, there is observation from every firm. Please have a look:
Example generated by -dataex-. To install: ssc install dataex
clear
input double gvkey long date byte group double num_trades
1004 19129 1 753
1004 19130 1 984
1004 19130 2 5
1004 19131 1 954
1004 19131 2 1
1004 19134 1 1115
1004 19135 1 1159
1004 19136 3 1
1004 19136 1 1643
1004 19136 2 6
1004 19137 1 945
end
format %d date
I am trying to group gvkey by group or date but unable to have unique ids. Your advice on this will be highly appreciated.
Thanks
Related Posts with Panel ID in Trade Groups
brant can only be used after ologitHi everyone, Using brant subcommand, I am trying to test the parallel regression assumption. I am us…
Hypothetical default rateDear Statalist, I have a dataset containing loans which are followed through time. I am running a l…
Is it possible to use two datasets at once?Hey STATA noob here, I'm wondering if it's possible to use variables from two different datasets at…
Agreement (kappa) Dear Statalisters, I have a 65 observation, we want to look at the variable only walking >=6 min…
Annual stock returnHey, I need your help. I need the follow variable "RETURN" in STATA. RETURN is the annual stock re…
Subscribe to:
Post Comments (Atom)
0 Response to Panel ID in Trade Groups
Post a Comment