I'm analysing a large survey dataset. Each data point has an individual key number and a household key number.
Individual Income is presented for each Individual. I need to create a new variable for each individual that reflects the total income from their household (the sum of the income of each household member). I have no clue how to do it, anyone to point me in the right direction?
Back in the dark ages when I used SPSS we would have used a COMPUTE command. The point and click version is described here:
https://www.google.com/search?q=spss+compute+variable&rlz=1C1CHBF_enUS847US847&oq=SPSS+COMPUTE&aqs=chrome.0.0j69i57j0l4.17318j0j8&sourceid=chrome&ie=UTF-8
Best, D. Booth
Hello Juan,
You should click on Transform>Compute variable. On the pop-up window, you will see 'target variable' on the top left. You can name it 'total income' (or whatever you like) then you should choose the variables (on the left) that you would like to sum up, adding '+' between each. Like:
income_1+income_2+income_3+....
When you click ok and go to your variable tab, you will find the new variable as 'total income' and on the data tab, you will find the sum up data.
Hope this is helpful.
Cheers,
Özge
Juan Jose Duque
Follow the following link it gives step by step instruction
https://libguides.library.kent.edu/SPSS/ComputeVariables
Cheers and Good Luck
- Badges
- Science topic
- Similar topics
- Mathematical Sciences
- Statistics
- Statistical Software
- SPSS