Nice ! What version of SPSS you are using ? When I make the step, the dialog box do give option to choose the option :Non-active dataset is keyed table
Thank you, if you have some occurrences of ID's that are in one dataset but not another, will this function work or does it only work when the cases are exactly the same?
How do you merge data from a repeated measures design where you have two key variables (person and time)? I can't put both in ascending order, so I keep getting error messages. so greatful for any hints
Lisa, depending on what kind of data you want and what kinds of analyses you want to run, you could a) create a new variable for both datasets that includes both ID and time, e.g., Bob_1, Bob_2, Bob_3, Sally_1, Sally_2, Sally_3 for a long-format merged dataset or you could b) update the variables in the second dataset so it says repeatedscale_2, repeatedmeasure_2, repeateditem_2, so it enters them as new variables for a wide-format dataset.
Depende do que se quer exatamente. Entretanto, se for para gerar as tabelas a partir da base de dados de um inquérito DHS, você vai precisar ter as bases de dados em SPSS. Segundo , é necessário criar as sintaxes para gerar as tabelas que você pretende gerar. Espero ter lhe ajudado. (me desculpa por ter os meus comentário em português )
Thank you for your helpful video! I actually had to use two key variables (just popped in id and year) for joining which worked equally well:-)
Thanks :) I needed to learn this before taking an assessment :)
Nice ! What version of SPSS you are using ? When I make the step, the dialog box do give option to choose the option :Non-active dataset is keyed table
I hope so version 26
yes it's the version 26 spss.
Thanks for the video. It helped me with my homework :)
Thanks, quite helpful!
Nice video. What does SPSS do when some cases are missing from one or both datasets?
Thank you, if you have some occurrences of ID's that are in one dataset but not another, will this function work or does it only work when the cases are exactly the same?
Did you find a solution to this etramway?
"jbiafra", I see what you did there ;)
How do you merge data from a repeated measures design where you have two
key variables (person and time)? I can't put both in ascending order,
so I keep getting error messages. so greatful for any hints
Lisa, depending on what kind of data you want and what kinds of analyses you want to run, you could a) create a new variable for both datasets that includes both ID and time, e.g., Bob_1, Bob_2, Bob_3, Sally_1, Sally_2, Sally_3 for a long-format merged dataset or you could b) update the variables in the second dataset so it says repeatedscale_2, repeatedmeasure_2, repeateditem_2, so it enters them as new variables for a wide-format dataset.
Use R:
merge(dataLong1, dataLong2)
Voila! B-)
Mam how can we can use SPSS for demographic health survey
Depende do que se quer exatamente. Entretanto, se for para gerar as tabelas a partir da base de dados de um inquérito DHS, você vai precisar ter as bases de dados em SPSS. Segundo , é necessário criar as sintaxes para gerar as tabelas que você pretende gerar. Espero ter lhe ajudado. (me desculpa por ter os meus comentário em português )
jello biafra DK