SPSS Statistics

Hello All,

I recently found a job that uses SPSS.  About 15-ish years ago I used SPSS and had taken several syntax classes.  I know the power of SPSS and what it can do.  However, I haven't touch it in over 15 years.  I am tasked with something that I think is very simple, however I do not remember for the life of me how to do what I am about to ask.  I am wondering if someone can help me.

Here is my SPSS question for the community.  

I have a survey data file, let's call it SurveyData.  The survey data has a few metadata variables plus all the survey data. Before I started at the company a now former employee somehow corrupted 2 variables in the metadata.  The to corrupted variables are String, one variable is called MemberType, the other is called MemberStatus.  

I can fix these two variables with another dataset which contains the metadata in a file called CorrectMetaData.  This file also has MemberType and MemberStatus (also String). I can key both files on Email addresses.

CorrectMetaData has ~100,000 cases.  SurveyData has ~1,000 cases.  What I would like to do is Merge the 2 correct variable from CorrectMetaData, into SurveyData.  I do not want to change anything else in the current SurveyData except for updating MemberType and MemberStatus.

Can someone please help me?  I attached some dummy records with some mocked up emails to protect the innocent.  

Thank you in advance for your help

Dan

Attachment(s)

SURVEYDATA.sav   1 KB 1 version

CORRECTMETADATA.sav   1 KB 1 version