SPSS Statistics

 View Only
Expand all | Collapse all

How to find duplicate in adjacent field

  • 1.  How to find duplicate in adjacent field

    Posted Fri March 10, 2023 09:09 AM
      |   view attached

    How can I find a duplicate only for adjacent fields? So to see if there are rows with value '1' for instance after a row of value '1'?



    ------------------------------
    Renee Damstra
    ------------------------------

    Attachment(s)



  • 2.  RE: How to find duplicate in adjacent field

    Posted Fri March 10, 2023 09:19 AM

    Hi. Check out the LAG function. You can find details on it in the Help, or online explanations such as this.



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