0

I have a large dataset of over 4000 cases with over 500 variables. I want to add this set of variables to another dataset containing most of the same cases but only around 10 variables.

Both of the datasets contain an ID variable that allows me to match the cases. The larger dataset is a keyed table because there are cases in there that aren't in the smaller set and are therefore of no interest to me.

I'm very comfortable with merging the files but my problem arises when I look at the new dataset. The variables are in there but all the values turn up missing. This only applies to the variables that were added to the active dataset. I checked to see if the key variable had any duplicates and it didn't.

I wonder why this happens, and if there is a way to fix this? I can add that I have done this very often before without this problem.

Gorgsenegger
  • 7,356
  • 4
  • 51
  • 89
Friðgeir
  • 3
  • 7
  • 1
    It sounds from your description ("all values are missing") is that you need to run a transformation (e.g. `EXECUTE`) to see the merged in values. If that is not the case if you have cases in the active file that aren't in the matched set of course those will be missing. – Andy W Apr 22 '14 at 17:30
  • Thank you Andy for this quick reply! Unfortunately I have tried to run a transformation to see if the process was pending without any resolution and all the cases are missing, even the ones I know for a fact are in both datasets. – Friðgeir Apr 23 '14 at 08:51
  • 1
    Then there is some other problem. You will need to post a code snippet and example datasets for anyone to be able to diagnose the problem though. – Andy W Apr 23 '14 at 12:10

0 Answers0