Hello,
I'm working with a dataset from Comtrade, which include information about import, export and their respective trade values for 3 different countries: Italy, Belgium and Israel.
The data looks like this:
tradeflow | reporter | partner | tradevalues
import | belgium | israel | 1891976735
export | belgium | israel | 2663650495
import | belgium | italy | 14696719360
export | belgium | italy | 21122317754
import | italy | belgium | 20047180815
export | italy | belgium | 15239360972
import | italy | israel | 927106045
export | italy | israel | 2942813832
Based on this, I'd like to generate a variable which shows the sum of import and export tradevalues by each combination of countries. For example, a variable which shows the sum of tradevalues for Belgium and Israel in the first two rows (say, 1891976735+2663650495) . Then, another sum for Belgium and Italy in the row 3 and row 4 (14696719360+21122317754).
Again, the idea is to generate a variable which shows import+export for each combination of reporter and partner.
Thanks!
Related Posts with Generating variable based on two groups
compare variable (gdp) developmentHey, I want to compare the development of log(gdp) of some countries in one graph. But for a better …
Stratify or include interaaction terms when assessing the associations for boys and girls between several exposure variables and outcomeDear all, I have a model with 6 exposure variables and some other covariates. I would like to analys…
Time-series regressionHello everyone, I'm new to the topic Stata, and have a rather simple question, although I could not…
Adding Interaction with lagged dependent variables for CML estimation using "cquad"I am trying to regress a dynamic binary fixed-effects model of the form \[ y_it = \alpha_i + y_[it-1…
Allocating monthly observation to daily dataHello, I am trying to allocate an observation which is recorded at the last day of a month to a dat…
Subscribe to:
Post Comments (Atom)
0 Response to Generating variable based on two groups
Post a Comment