SPSS Statistics

 View Only

 SPSS 31 Integrate new T2 data into existing database

Myriam Roy's profile image
Myriam Roy posted 08/19/26 12:20 PM

Hello,

I have a database with over 150 participants, 1 per row. I have T1 and T2 variables for each participants. I had used the merge files syntax to integrate the T2 data into the main database but only had T2 data for some of the participants. Now, I have T2 data for more participants I want to add it to the main database. However, when I try to use the merge files syntax, nothing happens since the variables are already in the database. I've been racking my brain trying to find a solution. What would be the simplest way to import this new T2 data in the main database? The new T2 data is for participants who currently do not have T2 data in the main database.

Thank you!

Jon Peck's profile image
Jon Peck IBM Champion posted 08/19/26 12:26 PM

The solution is to use the UPDATE command.  That command, oddly, doesn't have a built-in dialog box, but you can use Extensions > Extension Hub and search for UPDATE to add one to the Data > Merge Files menu.

Myriam Roy's profile image
Myriam Roy posted 08/19/26 12:40 PM

Thank you for the quick response! I'm looking in the Extension Hub but can't seem to find an extension by the name UPDATE. Would it be under a different umbrella term? Thank you.

Jon Peck's profile image
Jon Peck IBM Champion posted 08/19/26 12:47 PM

The site is doing something weird.  I hope this gets through.

If you don't see update in the Extension Hub, it probably means that it is already installed.  Check the Data > Merge Files menu.  The team was considering adding it when SPSS is installed.  You can also check the Installed box in the Extension Hub display to include things already installed.

Myriam Roy's profile image
Myriam Roy posted 08/19/26 01:35 PM

Yes, indeed. I found it in the merge files menu. It did exactly what I needed to merge my new data. Thank you so much!