formula needed to filter multiple variables with same value

[jam320]

Greetings,

 

I have a data set with 4 factor variables that use the same 5 point likert scale and a summary variable that employs the total of these. If there is a missing value (blank or 9) in two or more factors the summary variable is null. However, the summary variable is also null if only on factor variable is null as well. Therefore, I want to filter (and delete) any row when 2 or more of the factor variables exist.  This would allow me to create a recoded variables for rows that only have 1 missing factor variable by using the mean of the 3 intact factor variables. Finally the summary variable can be recoded to account for new data.

 

Jason May, MS

Evaluation Analyst, Learning & Performance Improvement

Beech Brook

P: 216-831-8520 x2389

F: 216-831-0436

 

CONFIDENTIALITY NOTE: Please be aware that e-mail communication can be intercepted in transmission or misdirected. Please consider communicating any sensitive information by telephone, fax, or mail. The information contained in this message may be privileged and confidential. If you are NOT the intended recipient, please notify Beech Brook immediately at [phone] and destroy this message.

[Bruce Weaver]

Look up the NVALID and NMISS functions.

jam320 wrote

Greetings,

I have a data set with 4 factor variables that use the same 5 point likert scale and a summary variable that employs the total of these. If there is a missing value (blank or 9) in two or more factors the summary variable is null. However, the summary variable is also null if only on factor variable is null as well. Therefore, I want to filter (and delete) any row when 2 or more of the factor variables exist.  This would allow me to create a recoded variables for rows that only have 1 missing factor variable by using the mean of the 3 intact factor variables. Finally the summary variable can be recoded to account for new data.

Jason May, MS
Evaluation Analyst, Learning & Performance Improvement
Beech Brook
P: 216-831-8520 x2389
F: 216-831-0436

CONFIDENTIALITY NOTE: Please be aware that e-mail communication can be intercepted in transmission or misdirected. Please consider communicating any sensitive information by telephone, fax, or mail. The information contained in this message may be privileged and confidential. If you are NOT the intended recipient, please notify Beech Brook immediately at [phone] and destroy this message.

[MLIves]

If the alpha for the 4 factor scores is high, you could use

Summary=rnd(mean.3(f1,f2,f3,f4)).

To calculate the summary as a mean if there are at least 3 valid responses to the factor variables.

OR

Summary=rnd(mean.3(f1,f2,f3,f4)*4).

To calculate it as a sum of the four scores.

 

If the alpha is not high (>.7) then this replacement should not be done.

 

Melissa

 

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of May, Jason
Sent: Thursday, March 20, 2014 1:46 PM
To: [hidden email]
Subject: [SPSSX-L] formula needed to filter multiple variables with same value

 

Greetings,

 

I have a data set with 4 factor variables that use the same 5 point likert scale and a summary variable that employs the total of these. If there is a missing value (blank or 9) in two or more factors the summary variable is null. However, the summary variable is also null if only on factor variable is null as well. Therefore, I want to filter (and delete) any row when 2 or more of the factor variables exist.  This would allow me to create a recoded variables for rows that only have 1 missing factor variable by using the mean of the 3 intact factor variables. Finally the summary variable can be recoded to account for new data.

 

Jason May, MS

Evaluation Analyst, Learning & Performance Improvement

Beech Brook

P: 216-831-8520 x2389

F: 216-831-0436

 

CONFIDENTIALITY NOTE: Please be aware that e-mail communication can be intercepted in transmission or misdirected. Please consider communicating any sensitive information by telephone, fax, or mail. The information contained in this message may be privileged and confidential. If you are NOT the intended recipient, please notify Beech Brook immediately at [phone] and destroy this message.

---

This correspondence contains proprietary information some or all of which may be legally privileged; it is for the intended recipient only. If you are not the intended recipient you must not use, disclose, distribute, copy, print, or rely on this correspondence and completely dispose of the correspondence immediately. Please notify the sender if you have received this email in error. NOTE: Messages to or from the State of Connecticut domain may be subject to the Freedom of Information statutes and regulations.