Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: table inquiry


From   "Riano, Alejandro" <ALEJANDROR@iadb.org>
To   statalist@hsphsun2.harvard.edu
Subject   st: table inquiry
Date   Mon, 7 Oct 2002 16:57:14 -0400

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
alejandror@iadb.org
==========================

*
*   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/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index