Date: Mon, 10 May 2004 12:20:38 -0600
Reply-To: "Jose G. Benuzillo" <email@example.com>
Sender: "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From: "Jose G. Benuzillo" <firstname.lastname@example.org>
Subject: Re: Missing Value Code?
Content-Type: text/plain; charset="US-ASCII"
DATA LIST LIST (",")/ SEX V1 V2 V3 V4 V5.
sort cases by sex.
/var1 to var5=mean(V1 to v5).
match files file= * /table='c:\temp\newdata.sav'
do repeat orig = V1 to v5 /copy=var1 to var5.
if (missing (orig)) orig=copy.
delete variables var1 to var5.
Jose Benuzillo, M.A.
Huntsman Cancer Institute
Cancer Control and Population Sciences
2000 Circle of Hope
Salt Lake City, UT 84112
From: Colin Valdiserri [mailto:Colin_Valdiserri@marketstrategies.com]
Sent: Monday, May 10, 2004 11:56 AM
Subject: Missing Value Code?
I'm looking for some example code in SPSS that will impute missing
based on subgroup means. That is, I would like to identify a grouping
variable and then pull the mean value from the group to fill in values
individuals. This needs to be done for about 40 variables across more
than 100 subgroup categories.
And then I will need to repeat this for two more projects that are
up soon. So while I can envision writing this code by hand with a
help from Excel, it would be great if I could find something else that
could easily and rapidly do the trick.
Any help would be appreciated
Colin M. Valdiserri, M.A.
Marketing Sciences Analyst
Market Strategies, Inc.
Phone: (734) 779-6826
Huntsman Cancer Institute wishes to promote open communication while protecting confidential and/or privileged information. If you have received this message in error, please inform the sender and delete all copies.