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
Pseudo out-of-sample forecast using loopsHello, I have tried running a code given to me to predict a pseudo out-of-sample forecast using a lo…
How to generate a dummy variable in the dataset as attached in this post?I want to generate a dummy variable. When the name for the position of "GS" is the same for the posi…
error for displaying a large numberHello, To merge, I needed to make a specific identifier for each row. As you can see below, for eac…
Splitting data within one variableHello! I have a variable with data entry as follows for each observation: XXX-XXXXX-X-X. Is there a…
stripplot: Getting rid of "graphs by ___ " note in lower leftI'm using the latest version stripplot (ran ssc install stripplot today) with both the over and by o…
Subscribe to:
Post Comments (Atom)
0 Response to Panel ID in Trade Groups
Post a Comment