HI, I HAVE A TABLE LIKE THIS:
table country_of_residence r_own_cur nation_resid if sec==1 & year>2000,
c(sum amount) col
----------------------------------------------------------------------------
-------------
| nation_resid and r_own_cur
| ----------- no resid ----------- ------------- resid
------------
country_of_residence | other curr own curr Total other curr own
curr Total
---------------------+------------------------------------------------------
-------------
Argentina | 3651 175.0875 3826.088 83175.71
2353.371 85529.08
Aruba | 16587.39 16587.39
Australia | 16744.07 4009.078 20753.15 75192.02
10518.44 85710.46
Austria | 11488.27 11488.27 85831.81
421.8379 86253.65
Bahamas | 1456.997 1456.997 399.0762
399.0762
Bahrain | 200
200
Barbados | 250
250
Belgium | 2930.945 2930.945 36100.76
1793.547 37894.31
Bermuda | 22609.09 22609.09 2326.132
2326.132
Brazil | 5138.669 5138.669 52679.8
52679.8
Bulgaria | 305.6384
305.6384
Canada | 14830.44 2024.991 16855.43 173391.4
28787.66 202179
Cayman Islands | 336036.1 336036.1 18577.04
18577.04
Chile | 2750.13 2750.13 6564.61
6564.61
China | 403 403 12925.87
12925.8
I WOULD LIKE TO KNOW IF THERE IS SOME WAY IN WHICH SOME OTHER COLUMNS COULD
BE ADDED TO THE TABLE. FOR EXAMPLE I'D LIKE TO HAVE A COLUMN THAT WOULD BE
THE RATIO BETWEEN OTHER_CURR AND OWN_CURR [FOR EXAMPLE FOR ARGENTINA I WOULD
LIKE TO HAVE (3651/175.0875) IS IT POSSIBLE TO DO THIS IN STATA ?
Alejandro Riano
==========================
Research Department
Inter-American Development Bank
(202) 623-1932
[email protected]
==========================
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
