RAAAP-3 SPSS Syntax Files

RAAAP-3 Data Cleansing v5.sps This syntax file is designed to take the raw SPSS data from the RAAAP-3 Qualtrics questionnaire and process it in order to, as per the RAAAP-3 Data Analysis Plan: 3. Data Identification - Removal of “non-data” (eg “click here to agree” = all are 1) 4. Systematic review of each variable - is it the correct type? 5. Data Cleansing - (eg -99  system missing) 6. Data Correcting - (eg missing response options backfilling based on free text (eg if a US state was missing from the choices this could be backcoded based on other responses)) 7. Data Anonymising (removal/redaction of any text that might give rise to identification) 8. Data Recoding - for clearer analysis [eg 8 (=1 year as a research admin) recode to 1] 9. Data Rationalisation (eg “years in research administration” into 5 year bands) 10. Data Consolidation (eg merging of data fields where appropriate [3 “other” into 1] [optional step] 11. Data Fusion (eg merging of two independent fields into a complex variable [eg Gender and Age into Gender-Age] for more insightful analyses) [optional step] <br> After the data are cleansed: RAAAP-3 create final datasets (for v5) 3rd May 2023.sps is used to: 11A Data splitting and saving - to aid anonynimity, eg separating free text from multichoice responses <br> Note that other steps from the data analysis plan are not conducted in this SPSS file, but elsewhere