SPSS/Excel: Removing data from one file that is present in another
I'm relatively new to SPSS and data processing within IBMs world, so I figured someone would be able to give me some advice/guidance. I have a large data set(List A) with survey information and another data set(List B) with a list of participants that would like to be removed from List A (future survey). The files are currently in excel format. Is there a way where I can easily remove all matching Cases from List A that are in List B (assuming that both list have the same variables) within SPSS? I've tried searching online but I can only find out how to remove duplicate copies on one list.
Thank you in advance!
Please log in to answer
Be the first to answer this question