You would probably want to
svyset PSU [pw=your weight], strata(strata)
svy : total investment, over( year sector )
nlcom ([investment]_subpop_2 - [investment]_subpop_1)/[investment]_subpop_1
or whatever labels the -total- command is going to give to individual
coefficients.
On Tue, Aug 3, 2010 at 8:29 AM, Jochen Späth <jochen.spaeth@iaw.edu> wrote:
> Dear Statalisters,
>
> I have a question about weights, especially about "double weights".
>
> I have micro-data on firms containing information about their investment behaviour (amounts) for several years. I then went on to calculate the firms' individual (discrete) growth rates of investment, i.e.
>
> rate_t = (inv_t - inv_t-1) / inv_t-1
>
> and wish to use these individual growth rates to calculate average growth rates for, say, economic sectors. Thereby, I'd like to attach an aweight to the -tabstat-, -table- or other suitable command, such that firms with higher investments in t-1 contribute a higher share to the average growth rate. This is, of course, straightforward in Stata.
>
> However, since I have sampled data I need to attach to this operation also a pweight to get information for the population instead of the sample.
>
> Can I calculate the average growth rates from the individual ones or do I need to -collapse- or -table, replace- my data? It seems that -svyset- could be what I am looking for, but it seems rather complicated. Is there a way to avoid the -svyset- command and to go on with simple -tabstat- or alike instead?
>
> Best,
> Jochen
>
> *
> * 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/
>
--
Stas Kolenikov, also found at http://stas.kolenikov.name
Small print: I use this email account for mailing lists only.
*
* 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/
