Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down at the end of May, and its replacement, statalist.org is already up and running.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

st: RE: Calculating average value using STATA program language


From   "Philip Ryan" <philip.ryan@adelaide.edu.au>
To   <statalist@hsphsun2.harvard.edu>
Subject   st: RE: Calculating average value using STATA program language
Date   Mon, 12 Sep 2011 13:40:41 +0930

<<>>

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/


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