Other Processing
Upon the completion of the final editing process and before the generation of tables for the report, a RECODE process has to be done to the data, based on the recommendations of the Washington Group (WG) Short and Extended Sets of functional difficulties for the different age groups.
This is done in Stata as well and the .do file used for the recode is also attached for reference. Different recodes were done for the Age group 2-4, 5-17 and 18+.
New Recoded variable include:
AGE 2-4
1. Seeing_2to4 and Seeing_2to4_id
2. Hearing_2to4 and Hearing_2to4_id
3. Walking_2to4 and Walking_2to4_id
4. Communication_2to4 and Communication_2to4_id
5. FineMotor_2to4 and FineMotor_2to4_id
1. Learning_2to4 and Learning_2to4_id
2. Playing_2to4 and Playing_2to4_id
3. Behaviour_2to4 and Behaviour_2to4_id
4. SOME_2to4, ALOT_2to4, CANNOT_2to4
5. FunctionalDifficulty_2to4 and FunctionalDifficulty_2to4_id
AGE 5-17
1. Seeing_5to17 Seeing_5to17_id
2. Hearing_5to17 Hearing_5to17_id
3. Walking_5to17 Walking_5to17_id
4. Cognition_5to17
5. Selfcare_5to17 Selfcare_5to17_id
6. Communication_5to17 Communication_5to17_id
7. Learning_5to17 Learning_5to17_id
8. Remembering_5to17 Remembering_5to17_id
9. Concentrating_5to17 Concentrating_5to17_id
10. AcceptingChange_5to17 AcceptingChange_5to17_id
11. Behaviour_7to17 Behaviour_7to17_id
12. MakeFriends_7to17 MakeFriends_7to17_id
13. Anxiety_5to17 Anxiety_5to17_id
14. Depression_5to17 Depression_5to17_id
15. SOME_5to17 ALOT_5to17 CANNOT_5to17
16. FunctionalDifficulty_5to17 FunctionalDifficulty_5to17_id
AGE 18+ (Short Set and Extended Set)
1. vis_ss_adult, VIS_ADULT_id - VISION
2. hear_ss_adult, HEAR_ADULT_id - HEARING
3. mob_ss_adult, MOB_ADULT_id - MOBILITY
4. com_ss_adult, COM_ADULT_id - COMMUNICATION
5. cog_ss_adult, cog_1_adult, cog_1a_adult ,cog_2_adult, cog_3_adult - COGNITION
6. rem_indicator, cog_indicator, COG_ADULT_id - REMEBERING
7. ub_ss_adult, SELFCARE_ADULT_id, ub_1_adult ,ub_2_adult, ub_indicator, UB_ADULT_id - UPPER BODY
8. anx_1_adult, anx_3_adult, anx_3y_adult, anx_indicator, ANX_ADULT_id - ANXIETY
9. dep_1_adult, dep_3_adult, dep_3y_adult, dep_indicator, DEP_ADULT_id - DEPRESSION
10. pain_2_adult, pain_4_adult, pain_4y_adult, pain_indicator, PAIN_ADULT_id - PAIN
11. tired_1_adult, tired_2_adult, tired_3_adult, tired_3y_adult, tired_indicator, TIRED_ADULT_id - TIRED
12. wg_ss_adult wg_ss_adult_id - SHORT SET
13. wg_es1_adult wg_es1_adult_id - EXTENDED SET 1
14. wg_es2_adult wg_es2_adult_id - EXTENDED SET 2
15. wg_es3_adult wg_es3_adult_id - EXTENDED SET 3
16. FunctionalDifficulty_all, FunctionalDifficulty_all_id - INDICATOR FOR ALL AGE GROUP
Filename for the recode is 'TSD WG Disability Identifier.do', which created:
1. New variables for the recodes
2. Wealth Index variable
3. Merging the weight variables into the final data
After the completion of the RECODE, generation of tables were then done. These tabulations were done in Stata as well, based on the table specifications provided by the statistical officer in charge of disability surveys at the Pacific Community (SPC).