SPSS Statistics

 View Only
  • 1.  Merge Error Message

    Posted Mon February 20, 2023 04:51 PM

    I'm merging pre and post data for a chi-square analyses merging on the key variable "school_code" which is numeric and I'm getting this message, but I don't understand what it means. 
    image.png


  • 2.  RE: Merge Error Message

    Posted Mon February 20, 2023 05:04 PM

    It means that in either or both of the files you are merging, the School_Code value "2" appears in more than 1 row of the dataset. Each row has to have a unique value for that variable, or the MATCH you specified won't know what to do.



    ------------------------------
    Rick Marcantonio
    Quality Assurance
    IBM
    ------------------------------



  • 3.  RE: Merge Error Message

    Posted Wed February 22, 2023 08:25 AM

    here is a script for removing duplicates.  there is also a point and click & aggregate way to do this.

    sort cases by school_code.

    if school_code=lag(school_code) drop=1.

    select if missing(drop).



    ------------------------------
    Art Jack
    ------------------------------