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 on April 23, and its replacement, statalist.org is already up and running.


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

Re: st: Spss's aggregate vs stata's collapse.


From   brendan.halpin@ul.ie (Brendan Halpin)
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: Spss's aggregate vs stata's collapse.
Date   Wed, 13 Apr 2011 12:13:56 +0100

On Wed, Apr 13 2011, Amadou DIALLO wrote:

> Brendan, Uli,
> Thanks for answers. Yes, it has to do with weights. Removing it yields
> same results. Apparently SPSS rounds non-integer weight to the nearest
> integer (the total weighted frequency, not individual weights (sic!):
> www.spsstools.net/Tutorials/WEIGHTING.pdf

SPSS is doing the wrong thing here, then. 

> I've tried Brendan's solution but this is not working. So far, I can't
> duplicate results and am stuck. Will continue checking.

If you really need to duplicate the results, you need to replicate
SPSS's "error". It may be enough to round the weight yourself. 

Going beyond that, you need to think about what you want the weights to
do. It might work to carry the weight variable through the -collapse-
(as the sum of the weights in the group) and weight the analysis
afterwards.

Brendan
-- 
Brendan Halpin,   Department of Sociology,   University of Limerick,   Ireland
Tel: w +353-61-213147  f +353-61-202569  h +353-61-338562;  Room F1-009 x 3147
mailto:brendan.halpin@ul.ie    ULSociology on Facebook: http://on.fb.me/fjIK9t
http://teaching.sociology.ul.ie/bhalpin/wordpress         twitter:@ULSociology
*
*   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