/build/static/layout/Breadcrumb_cap_w.png

Best Practices Question


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

09/24/2015 947 views
Hello,

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

Comments

  • Search the SPSS support site:
    https://www-01.ibm.com/software/analytics/subscriptionandsupport/spss.html

    On this website we handle software deployment/installations.

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

Share

 
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