Best Practices Question

SPSS/Excel: Removing data from one file that is present in another

09/24/2015 954 views

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.

Be the first to answer this question

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