My sincere apologies, I accidentally created this post twice: https://www.statalist.org/forums/for...d-be-matchable
- - -
I apologize in advance if this is completely obvious, however I couldn’t find any relevant information or forum posts.
I’m using a Structural Gravity Model to analyze the effects of a trade agreement. In the end, I get different results for changes in exports, imports and domestic trade in separate tables.
I‘m trying to display all of these in one table, rather than in three separate ones, and I would prefer to do this within Stata rather than in Excel/…
The problem is, that the variable names don’t match: for exports and domestic trade, I use 'exp' to get the results, for imports I use 'imp'.
The countries within those are all the same, so I believe it should be possible to match up these results with the collect command somehow? I just can’t seem to figure out how to do so.
The table commands generating my three separate results tables are as follows:
Exports: table exp if exp!=imp [aweight = BSL] , stat(mean CGeffect) name(exports)
Imports: table imp if exp!=imp [aweight = BSL] , stat(mean CGeffect) name(imports)
Domestic: table exp if exp==imp [aweight = BSL] , stat(mean CGeffect) name(exports)
…when I try to use (a very rudimentary because I’m still struggling) collect layout to combine these, I get the following error: „Your layout specification does not uniquely match any items. …“
I'm sure that i'm missing something obvious, but I’ve gone through the manual so many times now and just can’t seem to figure it out.
I would greatly appreciate any help or tips that point me in the right direction!!
- - -
I apologize in advance if this is completely obvious, however I couldn’t find any relevant information or forum posts.
I’m using a Structural Gravity Model to analyze the effects of a trade agreement. In the end, I get different results for changes in exports, imports and domestic trade in separate tables.
I‘m trying to display all of these in one table, rather than in three separate ones, and I would prefer to do this within Stata rather than in Excel/…
The problem is, that the variable names don’t match: for exports and domestic trade, I use 'exp' to get the results, for imports I use 'imp'.
The countries within those are all the same, so I believe it should be possible to match up these results with the collect command somehow? I just can’t seem to figure out how to do so.
The table commands generating my three separate results tables are as follows:
Exports: table exp if exp!=imp [aweight = BSL] , stat(mean CGeffect) name(exports)
Imports: table imp if exp!=imp [aweight = BSL] , stat(mean CGeffect) name(imports)
Domestic: table exp if exp==imp [aweight = BSL] , stat(mean CGeffect) name(exports)
…when I try to use (a very rudimentary because I’m still struggling) collect layout to combine these, I get the following error: „Your layout specification does not uniquely match any items. …“
I'm sure that i'm missing something obvious, but I’ve gone through the manual so many times now and just can’t seem to figure it out.
I would greatly appreciate any help or tips that point me in the right direction!!
