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
------------------------------
Dan Rangel
------------------------------