Hi there,
I am currently busy with my master thesis and I have the following question.
I want to create a variable called applicant credential (appl_credent), by combining the following two variables: western applicant credential and nonwestern applicant credential.
a participant either has a value for western applicant credential or for non-western applicant. Never for both at the same time!
Which means that if a participant has for example a value of 3.25 for western applicant credential, the value is "." (e.g. missing) for the non-western applicant credential. (see my attachment)
Now I am trying to create 1 variable called applicant credential and combine the two variables into one without losing data.
I just can't seem to find out how I have to do this. Thanks for your help!
Hello Esra,
Here's one way (assuming all cases have one OR the other credential value):
1. Open a syntax window (File/New/Syntax...)
2. Enter these commands:
compute appl_credent = Wes_appl_credent .
if sysmis(Wes_appl_credent) appl_credent = NonWes_appl_credent .
execute.
3. Highlight and run all three commands.
Good luck with your work.
Hello Esra,
Dr. Morse is correct for the situation you've described. However, you can check this link. It will help you to create these type of variables without any "syntax window".
Thanks
https://www.youtube.com/watch?v=Vf9HdT4Z7MQ
Another possibility is Transform - Compute Variable
appl_credent=MAX( Wes_appl_credent , NonWes_appl_credent )
Thank you so much! I did it the way David Morse explained me and it worked!
Amazing, thank you!
- Badges
- Science topic
- Similar topics
- Mathematical Sciences
- Statistics
- Statistical Software
- SPSS