SPSS Statistics

SPSS Statistics

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


#Analytics
#SPSSStatistics
#Analyticstools
 View Only

  • 1.  Error log when downloading from RedCAP EDC system

    Posted 06/24/26 09:37 AM

    Hello,

    SPSS rookie here.  I am downloading data from RedCAP to SPSS directly.  I have performed this task may times but am now having issues with getting an error log where the location of the error in the data is not being seen or is in a generated by the system like a "time stamp".  This is occurring after the eighth data entry.  I have gone through the data for the following data entries and am not seeing anything  Screen shot below:



    ------------------------------
    james venendaal
    ------------------------------


  • 2.  RE: Error log when downloading from RedCAP EDC system

    Posted 06/24/26 12:02 PM

    Looks as though the data you are connecting to has shifted.   I see those types of errors when I don't format the incoming dates properly or when the expected columns are no longer in the same format or in the same order.



    ------------------------------
    Laurinda Donaghey
    ------------------------------



  • 3.  RE: Error log when downloading from RedCAP EDC system

    Posted 06/25/26 09:04 AM

    Pay attention to the second line of that warning: An invalid numeric field has been found.  You are trying to read non-numeric values (e.g., 'N/A') into a numeric variable. 

    One solution would be to import those variables as strings, and then convert them to numeric if that is necessary or desirable.  



    ------------------------------
    Bruce Weaver
    ------------------------------



  • 4.  RE: Error log when downloading from RedCAP EDC system

    Posted 06/25/26 10:13 AM

    Hi James,

     

    Looks like 1 row (case 8(? Hard for me to see the number)) has 4 variables (starting columns) where there is a non-numeric value in a numeric field.

    The warnings are telling you that because SPSS can't translate these to numeric values, they have been set to missing.

    If you check the case in question in SPSS, and compare the values in those columns (you may have to guestimate which it is exactly) to the REDCap responses, you should be able to find the original problem.

     

    Melissa

     






Related Content