******************************************************************************************************* ******* AQOL-7D SPSS ALGORITHM (WITH MISSING VALUES) (CHE version 8 date 12 March 2015) **** ********************************************************************************** * THIS ALGORITHM (CHE version 8 date 12 March 2015) IS AN INTERIM RELEASE AND * MAY BE CHANGED WITHOUT NOTICE. * RESEARCHERS SHOULD CHECK WITH THE AQOL GROUP AT MONASH UNIVERSITY * FOR ANY MODIFICATION www.aqol.com.au*** ************************************************************************ * NOTE: This file analyses the 26 items of the AQoL-7D instrument and produces values for each dimension and a utility score for the overall instrument. ** If necessary contact angelo.iezzi@monash.edu ***************************************************************** *Variable names: For this algorithm, the variables in your questionnaire or database should be named * "aqol1, aqol2 ...aqol26". *Data entry: The first response in any item, the item best, is entered as ‘1’, the second as ‘2’, third as ‘3’ and so on. ************************************************************* * The dimensions are scaled on a "Dimension Worst Health State - Dimension Best Health State" scale * where DWHS = 0.00 and DBHS = 1.00. * These are NOT utility scores as they have not been evaluated on a life-death scale ************************************************************* *Missing Values: Note that missing data are represented by a blank and are handled by imputing values within each dimension. *Dimensions with 3-4 items will allow for 1 missing value to be imputed, dimensions with 6 items will allow for 2 missing values. *However, if more item responses in the dimensions are missing the observations will be dropped and there will not be a dimension score or an instrument score for the individual. ********************************************************************************** * aqol# are item responses in your data * dvQ# are item disvalues * Missing values represented by a blank or dot.** ***The algorithm is to be used for the instrument as a whole. It is not valid to calculate a score for one or two dimensions only. ** *After entering the item responses and running the program, the following scores will be calculated: ***1. Item Disvalues ***2. Dimension Values ***3. Overall Score on a 0-1 Disvalue Scale ***4. Overall Score on a Life-Death Scale ***5. Econometric Modelling ***6. AQoL 7D Utility Score ********************************************************************************************************* ********************************************************************************************************* *********************************** AQOL-7D Model. ******************************** ********************************************************************************************************* ********************************************************************************************************* Compute Q1 = aqol1. Compute Q2 = aqol2. Compute Q3 = aqol3. Compute Q4 = aqol4. Compute Q5 = aqol5. Compute Q6 = aqol6. Compute Q7 = aqol7. Compute Q8 = aqol8. Compute Q9 = aqol9. Compute Q10 = aqol10. Compute Q11 = aqol11. Compute Q12 = aqol12. Compute Q13 = aqol13. Compute Q14 = aqol14. Compute Q15 = aqol15. Compute Q16 = aqol16. Compute Q17 = aqol17. Compute Q18 = aqol18. Compute Q19 = aqol19. Compute Q20 = aqol20. Compute Q21 = aqol21. Compute Q22 = aqol22. Compute Q23 = aqol23. Compute Q24 = aqol24. Compute Q25 = aqol25. Compute Q26 = aqol26. EXECUTE . ********* IMPUTING MISSING VALUES IN DATABASE ********* ** Independent Living - Dimension 1** Compute ILmiss = Nmiss (Q1 to Q4). Do if ILmiss < 2. Do repeat A = Q1 to Q4. If (Missing (A)) A = RND(Mean (Q1 to Q4)). End repeat. End if. ** Relationships - Dimension 2** Compute RELmiss = Nmiss (Q5 to Q7). Do if RELmiss <2. Do repeat A = Q5 to Q7. If (Missing (A)) A = RND(Mean (Q5 to Q7)). End repeat. End if. ** Mental Health - Dimension 3** Compute MENmiss = Nmiss (Q8 to Q11). Do if MENmiss <2. Do repeat A = Q8 to Q11. If (Missing (A)) A = RND(Mean (Q8 to Q11)). End repeat. End if. ** Coping - Dimension 4** Compute COPmiss = Nmiss (Q12 to Q14). Do if COPmiss <2. Do repeat A = Q12 to Q14. If (Missing (A)) A = RND(Mean (Q12 to Q14)). End repeat. End if. ** Pain - Dimension 5** Compute PAINmiss = Nmiss (Q15 to Q17). Do if PAINmiss <2. Do repeat A = Q15 to Q17. If (Missing (A)) A = RND(Mean (Q15 to Q17)). End repeat. End if. ** Senses - Dimension 6** Compute SENmiss = Nmiss (Q18 to Q20). Do if SENmiss <2. Do repeat A = Q18 to Q20. If (Missing (A)) A = RND(Mean (Q18 to Q20)). End repeat. End if. ** VisQoL - Dimension 7** Compute VISmiss = Nmiss (Q21 to Q26). Do if VISmiss <3. Do repeat A = Q21 to Q26. If (Missing (A)) A = RND(Mean (Q21 to Q26)). End repeat. End if. Execute. *** Dimension 1. Independent Living*** ***1. Household Help*** if (Q1=1) dvQ1=0. if (Q1=2) dvQ1=0.073. if (Q1=3) dvQ1=0.435. if (Q1=4) dvQ1=0.820. if (Q1=5) dvQ1=1. *** 2.Getting Around Outside*** if (Q2=1) dvQ2=0. if (Q2=2) dvQ2=0.033. if (Q2=3) dvQ2=0.240. if (Q2=4) dvQ2=0.471. if (Q2=5) dvQ2=0.840. if (Q2=6) dvQ2=1. *** 3.Walking*** if (Q3=1) dvQ3=0. if (Q3=2) dvQ3=0.041. if (Q3=3) dvQ3=0.251. if (Q3=4) dvQ3=0.570. if (Q3=5) dvQ3=0.827. if (Q3=6) dvQ3=1. *** 4.Personal care*** if (Q4=1) dvQ4=0. if (Q4=2) dvQ4=0.040. if (Q4=3) dvQ4=0.297. if (Q4=4) dvQ4=0.797. if (Q4=5) dvQ4=1. ***Dimension 2. Relationships*** ***4.Intimate*** if (Q5=1) dvQ5=0. if (Q5=2) dvQ5=0.074. if (Q5=3) dvQ5=0.461. if (Q5=4) dvQ5=0.841. if (Q5=5) dvQ5=1. ****6.family role*** if (Q6=1) dvQ6=0. if (Q6=2) dvQ6=0.193. if (Q6=3) dvQ6=0.759. if (Q6=4) dvQ6=1. *** 7.Community role*** if (Q7=1) dvQ7=0. if (Q7=2) dvQ7=0.197. if (Q7=3) dvQ7=0.648. if (Q7=4) dvQ7=1. *** Dimension 3. Mental Health*** ***8. Despair*** if (Q8=1) dvQ8=0. if (Q8=2) dvQ8=0.133. if (Q8=3) dvQ8=0.392. if (Q8=4) dvQ8=0.838. if (Q8=5) dvQ8=1. ***9. Worried*** if (Q9=1) dvQ9=0. if (Q9=2) dvQ9=0.142. if (Q9=3) dvQ9=0.392. if (Q9=4) dvQ9=0.824. if (Q9=5) dvQ9=1. ***10. Sad*** if (Q10=1) dvQ10=0. if (Q10=2) dvQ10=0.097. if (Q10=3) dvQ10=0.330. if (Q10=4) dvQ10=0.784. if (Q10=5) dvQ10=1. ***11.Calm*** if (Q11=1) dvQ11=0. if (Q11=2) dvQ11=0.064. if (Q11=3) dvQ11=0.368. if (Q11=4) dvQ11=0.837. if (Q11=5) dvQ11=1. *** Dimension 4. coping*** ***12. energy*** if (Q12=1) dvQ12=0. if (Q12=2) dvQ12=0.056. if (Q12=3) dvQ12=0.338. if (Q12=4) dvQ12=0.722. if (Q12=5) dvQ12=1. ***13. Control*** if (Q13=1) dvQ13=0. if (Q13=2) dvQ13=0.055. if (Q13=3) dvQ13=0.382. if (Q13=4) dvQ13=0.774. if (Q13=5) dvQ13=1. ***14 coping*** if (Q14=1) dvQ14=0. if (Q14=2) dvQ14=0.057. if (Q14=3) dvQ14=0.423. if (Q14=4) dvQ14=0.826. if (Q14=5) dvQ14=1. *** Dimension 5. Pain*** ***15.Serious Pain*** if (Q15=1) dvQ15=0. if (Q15=2) dvQ15=0.133. if (Q15=3) dvQ15=0.642. if (Q15=4) dvQ15=1. ***16. Pain*** if (Q16=1) dvQ16=0. if (Q16=2) dvQ16=0.200. if (Q16=3) dvQ16=0.758. if (Q16=4) dvQ16=1. ***17. Pain interferes*** if (Q17=1) dvQ17=0. if (Q17=2) dvQ17=0.072. if (Q17=3) dvQ17=0.338. if (Q17=4) dvQ17=0.752. if (Q17=5) dvQ17=1. ***Dimension 6. Senses*** ***18. Vision*** if (Q18=1) dvQ18=0. if (Q18=2) dvQ18=0.033. if (Q18=3) dvQ18=0.223. if (Q18=4) dvQ18=0.622. if (Q18=5) dvQ18=0.843. if (Q18=6) dvQ18=1. ***19. Hearing*** if (Q19=1) dvQ19=0. if (Q19=2) dvQ19=0.024. if (Q19=3) dvQ19=0.205. if (Q19=4) dvQ19=0.586. if (Q19=5) dvQ19=0.826. if (Q19=6) dvQ19=1. ***20. Communicate*** if (Q20=1) dvQ20=0. if (Q20=2) dvQ20=0.187. if (Q20=3) dvQ20=0.695. if (Q20=4) dvQ20=1. *** Dimension 7.VisQoL*** ***21.Injure*** if (Q21=1) dvQ21=0. if (Q21=2) dvQ21=0.096. if (Q21=3) dvQ21=0.386. if (Q21=4) dvQ21=0.687. if (Q21=5) dvQ21=1. ***22. Cope with demand*** if (Q22=1) dvQ22=0. if (Q22=2) dvQ22=0.019. if (Q22=3) dvQ22=0.143. if (Q22=4) dvQ22=0.360. if (Q22=5) dvQ22=0.751. if (Q22=6) dvQ22=1. ***23.Friendships (7=not applicable, I have no friendships)*** if (Q23=1) dvQ23=0. if (Q23=2) dvQ23=0.018. if (Q23=3) dvQ23=0.226. if (Q23=4) dvQ23=0.506. if (Q23=5) dvQ23=0.764. if (Q23=6) dvQ23=1. if (Q23=7) dvQ23=0.018. ***24.Assistance*** if (Q24=1) dvQ24=0. if (Q24=2) dvQ24=0.093. if (Q24=3) dvQ24=0.295. if (Q24=4) dvQ24=0.683. if (Q24=5) dvQ24=1. if (Q24=6) dvQ24=0. ***25.Roles*** if (Q25=1) dvQ25=0. if (Q25=2) dvQ25=0.014. if (Q25=3) dvQ25=0.142. if (Q25=4) dvQ25=0.377. if (Q25=5) dvQ25=0.733. if (Q25=6) dvQ25=1. ***26. Confidence*** if (Q26=1) dvQ26=0. if (Q26=2) dvQ26=0.012. if (Q26=3) dvQ26=0.129. if (Q26=4) dvQ26=0.342. if (Q26=5) dvQ26=0.670. if (Q26=6) dvQ26=1. EXECUTE . ***************************************************************************************************************************** ***2. MODELLING DIMENSIONS ***************************************************************************************************************************** *** The dimensions are scaled on a "Dimension Worst Health State-Dimension Best Health State" scale *** *** where DWHS = 0.00 and DBHS = 1.00. *************** **Example for 3 item dimension: **dvD1 = 1/kD1[(1+kD1*w1*duX1j)*(1+kD1*w2*duX2j)*(1+kD1*w3*duX3j)-1] **where dvD1 = Dimension 1 disvalue ** kD1 = scaling constant for Dimension 1 ** w1 = item 1 item worst disvalue (ave value) ** (using 0-1 dimension best-dimension worst scale) ** dvX1j = item 1 disvalue for jth item level **vD1=1-dvD1 ***DIMENSION 1 - IND LIV. ***DIMENSION SCALING CONSTANT kD1=-0.978. ***IND LIV HAS 4 ITEMS. ***ITEM WORST WEIGHTS (Wi) . ** w1=0.385412. ** w2=0.593819. ** w3=0.630323. ** w4=0.794888. **4 item formula **dvD1=(1/kD1)*[(1+(kD1*w1*dvQ1))*(1+(kD1*w2*dvQ2))*(1+(kD1*w3*dvQ3))*(1+(kD1*w4*dvQ4))-1]. Compute dvD1=(1/-0.978)*((1+(-0.978*0.385412*dvQ1))*(1+(-0.978*0.593819*dvQ2))*(1+(-0.978*0.630323*dvQ3))*(1+(-0.978*0.794888*dvQ4))-1). EXECUTE. **Variable dvD1= "Disvalue for Dimension 1 - Independent Living". ***DIMENSION 2 - REL. ***DIMENSION SCALING CONSTANT kD2 = -0.923. ***REL HAS 3 ITEMS. ***ITEM WORST WEIGHTS (Wi). ** w5=0.64303. ** w6=0.697742. ** w7=0.508658. **3 item formula **dvD2=(1/kD2)*[(1+(kD2*w5*dvQ5))*(1+(kD2*w6*dvQ6))*(1+(kD2*w7*dvQ7))-1]. Compute dvD2=(1/-0.923)*((1+(-0.923*0.64303*dvQ5))*(1+(-0.923*0.697742*dvQ6))*(1+(-0.923*0.508658*dvQ7))-1). EXECUTE. **Variable dvD2 = " Disvalue for Dimension 2 - Relationships" ***DIMENSION 3 - MEN. ***DIMENSION SCALING CONSTANT kD3 = -0.983 ***MEN HAS 4 ITEMS ***ITEM WORST WEIGHTS (Wi) ** w8=0.640377 ** w9=0.588422 ** w10=0.648748 ** w11=0.71122 **4 item formula **dvD3=(1/kD3)*[(1+(kd3*w8*dvQ8))*(1+(kD3*w9*dvQ9))*(1+(kD3*w10*dvQ10))*(1+(kD3*w11*dvQ11))-1] Compute dvD3=(1/-0.983)*((1+(-0.983*0.640377*dvQ8))*(1+(-0.983*0.588422*dvQ9))*(1+(-0.983*0.648748*dvQ10))*(1+(-0.983*0.71122*dvQ11))-1). EXECUTE. **Variable dvD3 = "Disvalue for Dimension 3 - Mental Health" ***DIMENSION 4 - COP. ***DIMENSION SCALING CONSTANT kD4 = -0.930 ***COP HAS 3 ITEMS ***ITEM WORST WEIGHTS (Wi) ** w12=0.415694 ** w13=0.636994 ** w14=0.773296 **3 item formula. **dvD4=(1/kD4)*[(1+(kD4*w12*dvQ12))*(1+(kD4*w13*dvQ13))*(1+(kD4*w14*dvQ14))-1]' Compute dvD4=(1/-0.930)*((1+(-0.930*0.415694*dvQ12))*(1+(-0.930*0.636994*dvQ13))*(1+(-0.930*0.773296*dvQ14))-1). EXECUTE. **Variable dvD4 = "Disvalue for Dimension 4 - Coping". ***DIMENSION 5 - PAIN. ***DIMENSION SCALING CONSTANT kD5 = -0.962 ***PAIN HAS 3 ITEMS ***ITEM WORST WEIGHTS (Wi) ** w15=0.631833 ** w16=0.767573 ** w17=0.652241 **3 item formula **dvD5=(1/kD5)*[(1+(kD5*w15*dvQ15))*(1+(kD5*w16*dvQ16))*(1+(kD5*w17*dvQ17))-1]. Compute dvD5=(1/-0.962)*((1+(-0.962*0.631833*dvQ15))*(1+(-0.962*0.767573*dvQ16))*(1+(-0.962*0.652241*dvQ17))-1). EXECUTE. **Variable dvD5 ="Disvalue for Dimension 5 - Pain" ***DIMENSION 6 - SEN. ***DIMENSION SCALING CONSTANT kD6 = -0.851 ***SEN HAS 3 ITEMS ***ITEM WORST WEIGHTS (Wi) ** w18=0.580696 ** w19=0.463022 ** w20=0.604613 **3 item formula **dvD6=(1/kD6)*[(1+(kD6*w18*dvQ18))*(1+(kD6*w19*dvQ19))*(1+(kD6*w20*dvQ20))-1]. Compute dvD6=(1/-0.851)*((1+(-0.851*0.580696*dvQ18))*(1+(-0.851*0.463022*dvQ19))*(1+(-0.851*0.604613*dvQ20))-1). EXECUTE. **Variable dvD6 "Disvalue for Dimension 6 - Senses". ***DIMENSION 7 - VIS **DIMENSION SCALING CONSTANT kD7=-0.833 ***VIS HAS 6 ITEMS ***ITEM WORST WEIGHTS (Wi) *w21= 0.2696557 * w22= 0.3697268 * w23= 0.3078306 * w24= 0.2971339 * w25= 0.3286885 * w26= 0.2810792 Compute dvD7=(1/-0.833)*((1+(-0.833*0.2696557*dvQ21))*(1+(-0.833*0.3697268*dvQ22))*(1+(-0.833*0.3078306*dvQ23))* (1+(-0.833*0.2971339*dvQ24))*(1+(-0.833*0.3286885*dvQ25))*(1+(-0.833*0.2810792*dvQ26))-1). EXECUTE. **Variable dvD7 = "Disvalue for Dimension 7 - VisQoL". *************************************************************************************************************************** ***3. OVERALL SCORE ON A 0-1 DISUTILITY SCALE*** *************************************************************************************************************************** *DIMENSION SCALING CONSTANT kA = -0.98 ***DIMENSION WORST WEIGHTS (wDi) * wD1=0.4724105 * wD2=0.4477805 * wD3=0.4788146 * wD4=0.3454342 * wD5=0.5920923 * wD6=0.637341 * wD7=0.8656279 *scaling factor for wDi = 1/1.118741 = 0.893862 **7item formula **duaqol = (1/kA)*[(1+(kA*wD1*0.8*dvD1))*(1+(kA*wD2*0.8*dvD2))*(1+(kA*wD3*0.8*dvD3))*(1+(kA*wD4*0.8*dvD4))*(1+(kA*wD5*0.8*dvD5))* (1+(kA*wD6*0.8*dvD6))* (1+(kA*wD7*0.8*dvD7))-1]. Compute duaqol=(1/-0.98)*((1+(-0.9*0.4724105*0.883251*dvD1))*(1+(-0.98*0.4477805*0.883251*dvD2))*(1+(-0.98*0.4788146*0.883251*dvD3))* (1+(-0.98*0.3454342*0.883251*dvD4))*(1+(-0.98*0.5920923*0.883251*dvD5))*(1+(-0.98*0.637341*0.883251*dvD6))*(1+(-0.98*0.8656279*0.883251*dvD7))-1). EXECUTE. **************************************************************************************************************************** ***4. OVERALL SCORE ON A LIFE-DEATH DISUTILITY SCALE*** **************************************************************************************************************************** **Scaling constant for LIFE DEATH scale, wld = 1.132181 ** duaqolld = wld*duaqol Compute duaqolld = 1.132181*duaqol. EXECUTE. Compute duAQoL_7D_corrPAT = (0.6495926*duaqolld) - (0.1241398*dvD5) - (0.106241*dvD6). EXECUTE. Compute vIL = (1- dvD1). Compute vREL = (1- dvD2). Compute vMH = (1- dvD3). Compute vCop = (1- dvD4). Compute vPain = (1- dvD5). Compute vSen = (1- dvD6). Compute vVisQoL = (1- dvD7). Compute AQoL_7D_Patient_Utility = 1 - duAQoL_7D_corrPAT. EXECUTE. VARIABLE LABELS vIL 'AQoL-7D INDEPENDENT LIVING dimension VALUE' vREL 'AQoL-7D RELATIONSHIPS dimension VALUE' vMH 'AQoL-7D MENTAL HEALTH dimension VALUE' vCop 'AQoL-7D COPING dimension VALUE' vPain 'AQoL-7D PAIN dimension VALUE' vSen 'AQoL-7D SENSE dimension VALUE' vVisQoL ' AQoL-7D VISQOL dimension VALUE' AQoL_7D_Patient_Utility ' AQoL_7D_Patient_Utility SCORE'. EXECUTE. DESCRIPTIVES VARIABLES=vIL vREL vMH vCop vPain vSen vVisQoL AQoL_7D_Patient_Utility /STATISTICS=MEAN STDDEV RANGE MIN MAX SEMEAN. Execute. Delete Variables Q1 Q2 Q3 Q4 Q5 Q6 Q7 Q8 Q9 Q10 Q11 Q12 Q13 Q14 Q15 Q16 Q17 Q18 Q19 Q20 Q21 Q22 Q23 Q24 Q25 Q26 ILmiss RELmiss MENmiss COPmiss PAINmiss SENmiss VISmiss dvQ1 dvQ2 dvQ3 dvQ4 dvQ5 dvQ6 dvQ7 dvQ8 dvQ9 dvQ10 dvQ11 dvQ12 dvQ13 dvQ14 dvQ15 dvQ16 dvQ17 dvQ18 dvQ19 dvQ20 dvQ21 dvQ22 dvQ23 dvQ24 dvQ25 dvQ26 dvD1 dvD2 dvD3 dvD4 dvD5 dvD6 dvD7 duaqol duaqolld duAQoL_7D_corrPAT. Execute.