Miss into Mean(Vars)

[Ribeiro-2]

Hi listers,

Is there a function at SPSS that we can replace the missing values by the
mean of a set of variables response. I would like that the function computes
the mean.
I mean that:

Obs Var1 Var2 Var3 Mean
1    5     .    1   3
2    4     4    .   4

Obs Var1 Var2 Var3 Mean
1    5     3    1   3
2    4     2    4   4

Thanks in advance,

Marcio

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[vlad simion]

Hi Marcio,

take a look at :
http://spsstools.net/Syntax/WorkWithMissing/ConditionallyReplacingMissingByMean.txt

Hth,
Vlad


On Nov 10, 2007 11:24 PM, Ribeiro <[hidden email]> wrote:

> Hi listers,
>
> Is there a function at SPSS that we can replace the missing values by the
> mean of a set of variables response. I would like that the function
> computes
> the mean.
> I mean that:
>
> Obs Var1 Var2 Var3 Mean
> 1    5     .    1   3
> 2    4     4    .   4
>
> Obs Var1 Var2 Var3 Mean
> 1    5     3    1   3
> 2    4     2    4   4
>
> Thanks in advance,
>
> Marcio
>
> =====================
> To manage your subscription to SPSSX-L, send a message to
> [hidden email] (not to SPSSX-L), with no body text except the
> command. To leave the list, send the command
> SIGNOFF SPSSX-L
> For a list of commands to manage subscriptions, send the command
> INFO REFCARD
>

--
Vlad Simion
Data Analyst
Tel:      [phone]

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[ViAnn Beadle]

Do you want to create a mean across variables for a given case, but only
when one of them is missing? What happens if all the variables are
not-missing?

I don't understand the result for the second observation in the second set
of rows?

Have you looked at the MEAN function in transformations?


-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Ribeiro
Sent: Saturday, November 10, 2007 2:24 PM
To: [hidden email]
Subject: Miss into Mean(Vars)

Hi listers,

Is there a function at SPSS that we can replace the missing values by the
mean of a set of variables response. I would like that the function computes
the mean.
I mean that:

Obs Var1 Var2 Var3 Mean
1    5     .    1   3
2    4     4    .   4

Obs Var1 Var2 Var3 Mean
1    5     3    1   3
2    4     2    4   4

Thanks in advance,

Marcio

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD