Re: st: RE: Calculating average value using STATA program language

[Suryadipta Roy <sroy2138@gmail.com>]

Phil,

-collapse- works great. I spent quite some time with the loops today!
Thank you so much!

Best regards,
Suryadipta.

On Mon, Sep 12, 2011 at 12:10 AM, Philip Ryan
<philip.ryan@adelaide.edu.au> wrote:
> <<>>
>
> Instead of -foreach- or -forvalues- loops, try using -collapse-, for
> example:
>
> collapse (sum) sum_imp=imports (mean) avg_imp=imports, by(importer exporter
> isic)
>
> Phil
>
> Philip Ryan
> University of Adelaide
>
> -----Original Message-----
> From: owner-statalist@hsphsun2.harvard.edu
> [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Suryadipta Roy
> Sent: Monday, 12 September 2011 1:17 PM
> To: statalist@hsphsun2.harvard.edu
> Subject: st: Calculating average value using STATA program language
>
> Hello everyone,
> I am a newbie in terms of writing STATA codes, and intend to get that
> corrected pretty soon. Meanwhile, I was wondering if any one could
> help me with the following. I have been trying use foreach/forvalues
> without any success for some time. Any help/suggestion/hint is greatly
> appreciated.
>
> importer        exporter        year    isic     imports   sum_import
> avg_import
> AUS     FRA     1979    311     8       24      12
> AUS     FRA     1980    311     16      24      12
> AUS     FRA     1979    313     0       0       0
> AUS     FRA     1980    313     0       0       0
> AUS     GAB     1979    369     0       0       0
> AUS     GBR     1976    311     10      30      10
> AUS     GBR     1977    311     20      30      10
> AUS     GBR     1978    311     0       30      10
> AUT     CAN     1977    312     10      10      10
> AUT     CAN     1978    390     20      20      20
> FRA     AUS     1976    311     5       10      5
> FRA     AUS     1977    311     5       10      5
> FRA     AUT     1980    369     4        4      4
>
> In the hypothetical dataset above, I am trying to create the last two
> columns (sum_import, and avg_import) from the "imports" column. For
> the first column, the idea is to calculate the sum of imports e.g.
> from FRA to AUS for each industry category (isic). Thus for the isic
> category 311, the sum of imports in 1979 and 1980 is 8 + 16 = 24, and
> the average in the two years is 12. Similarly, there were no trade
> between AUS and GAB in 1979 for the industry category 369, and hence
> the sum and the average value of imports = 0. The actual dataset has
> over 200 countries covering data from 1976 - 1980 and I am trying to
> calculate the average of the imports between 1976- 1980 in each
> industry category. There are 28 such industry categories.
>
> I remain grateful for any help.
>
> Sincerely,
> Suryadipta.
> *
> *   For searches and help try:
> *   http://www.stata.com/help.cgi?search
> *   http://www.stata.com/support/statalist/faq
> *   http://www.ats.ucla.edu/stat/stata/
>
> *
> *   For searches and help try:
> *   http://www.stata.com/help.cgi?search
> *   http://www.stata.com/support/statalist/faq
> *   http://www.ats.ucla.edu/stat/stata/
>

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/