Date: Mon, 24 Jul 2006 08:09:12 -0500
Reply-To: "Beadle, ViAnn" <email@example.com>
Sender: "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From: "Beadle, ViAnn" <firstname.lastname@example.org>
Subject: Re: weighted numbers
Content-Type: text/plain; charset="us-ascii"
Weights don't apply to AGGREGATE; only to statistical procedures.
From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU] On Behalf Of Albert-jan Roskam
Sent: Monday, July 24, 2006 7:52 AM
Subject: weighted numbers
I want to calculate the relative proportions of people
within educational categories, stratified by sex and
country. I use a standardized weight that corrects for
sample selection bias. Could anybody tell me
why-oh-why the two methods listed below yield
(slightly) different results? The N function of the
aggregate counts the weighed number of cases within
the break group. So why are the AGGREGATE results
identical to the output I get using SUMMARIZE with an
UNweighted sample? Am I missing something?
Thanks a lot in advance!
weight by w_plus.
** Method 1.
compute dummy = 1.
summarize tables = dummy by sex by country3 by educat
/ cells = npct (educat).
** Method 2.
aggregate outfile = "d:\temp\tmp.sav" / break = sex
country3 educat / n = n.
aggregate outfile = * / break = sex country3 / n_tot =
match files table = * / file = "d:\temp\tmp.sav" / by
= sex country3.
compute pct = (n / n_tot ) * 100.
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around