Date: Tue, 4 Nov 2003 17:15:25 +0100
Reply-To: Staffan Lindberg <Staffan.Lindberg@fhi.se>
Sender: "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From: Staffan Lindberg <Staffan.Lindberg@fhi.se>
Subject: SV: Averaging across columns with missing values
Content-Type: text/plain; charset="iso-8859-1"
It demands only 1 valid variable (not containing missing)for the whole
array. If you demand 2, just write sum.2
National Institute of Public Health
Från: chris fisher [mailto:firstname.lastname@example.org]
Skickat: den 4 november 2003 17:12
Ämne: Averaging across columns with missing values
What would the syntax be for averaging across ten columns of data, where
some of the columns had system missing data???
I tried a simple (day1+day2+day3+day4....)/10
But it only works for the cases that have values in all 10 columns. I can't
just do a fill or set missing equal to zero because all subjects were not
expected to have 10 data points, it is ok if someone only has day1 and day2,
but I'd still like to know the average.