I have a problem with a dataset. I have a dataset in long format for individuals over time. However as i have duplicate cases for individuals within a specific year (which i don not want) i cannot start my analysis. this duplicates are created because certain variables differ however most do are unique and thus double. The idea is to merge the cases so that i have one case for each year (instead of two) for an indivual. However i would like spss to merge those variables that are different from each other in that same year into the new single case. And if needed create new variables so that no information will be lost but i can do my longitudinal design.
Hope someone can help me (i really want to finish my academic carreer soon :p)