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!

1 Comment   [ + ] Show comment
  • Search the SPSS support site:

    On this website we handle software deployment/installations. - dedenker 5 years ago

Answers (0)

Be the first to answer this question

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login


This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ