|
Hello. I have the new SPSS 19. for students. I am trying to import some data collected over the internet.
I have sections of my data which only certain participants have answered (i.e. if they indicated 'yes' in one section, then further questions would appear. If they stated 'No', then further questions would not appear.
For some reason, when I copy and paste my data into SPSS from Notepad or Excel, every blank response in which participants did not answer a question or were not presented with the question, SPSS has allocated '0'. This is an issue, as responses on all of my variables are coded from 0-5, so it appears that a lot of participants have psychological problems when in fact they didn't get asked the question.
I have tried to recode 'missing variables' in several ways (manually for each variable in 'variable view'; using syntax etc) but it keeps coding the missing variables as 0, instead of 98 for user missing and 99 for system-missing which I want. The old version of SPSS did what I needed to, but this new version has not distinguished between system-missing and user-missing. Is there another setting in SPSS (apart from defining missing variables in variable view) which would allow me to import data, and see which data is missing?
Thanks!
|