SPSS Statistics

SPSS Statistics

Your hub for statistical analysis, data management, and data documentation. Connect, learn, and share with your peers! 

 View Only

  • 1.  Double key data entry checks

    Posted Wed February 01, 2023 08:42 AM
    Hi,

    I have survey responses for about 1000 respondents that we would like to enter using a double entry method (two different people entering responses for each survey). There are over 400 variables per survey. Is there a way in SPSS to easily check for discrepancies between the two entries, and flag them so they can be resolved?

    Thanks.
    CP

    ------------------------------
    Colleen Poon
    ------------------------------


  • 2.  RE: Double key data entry checks

    Posted Wed February 01, 2023 09:51 AM
    Take a look at the COMPARE DATASETS procedure (Data > Compare Datasets).  It let's you choose what variables to compare and whether to check variable dictionaries as well as values or not.

    --



    Original Message


  • 3.  RE: Double key data entry checks

    Posted Wed February 01, 2023 01:11 PM
    This is right off UCLA's advanced research computing site.

    data list list
    /id * test1 (A2) test2.
    begin data.
    1 11 80
    2 55 88
    3 44 77
    4 66 33
    end data.
    dataset name rater3.

    data list list
    /id test1 test2.
    begin data.
    1 11 80
    2 55 88
    3 44 78
    4 66 33
    5 77 22
    end data.
    dataset name rater4.

    dataset activate rater3.

    compare datasets
    /compdataset rater4
    /variables all
    /output varproperties = all.

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

    Original Message


  • 4.  RE: Double key data entry checks

    Posted Tue February 07, 2023 12:31 PM
    Thank you for your responses regarding the Compare Datasets procedure.

    In terms of doing this type of data entry check from independent datasets, does the Data Preparation module from SPSS provide any added benefit? I'm wondering if it would be worth the investment.

    ------------------------------
    Colleen
    ------------------------------

    Original Message


  • 5.  RE: Double key data entry checks

    Posted Tue February 07, 2023 03:14 PM
    The VALIDATEDATA procedure is now available in the SPSS Base Edition.  It used to be a separate option.

    This procedure does not help to check two datasets against each other, but it can apply validation rules on a per question basis, which would help to spot entry errors.

    --



    Original Message