Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

SPSS Truncated Responses

  • blocka
  • blocka's Avatar Topic Author
  • Offline
  • Platinum Member
  • Platinum Member
More
7 years 1 month ago #158825 by blocka
SPSS Truncated Responses was created by blocka
We are noticing differences in the SPSS data file depending on whether we extract the SPSS file for ‘All responses’ versus ‘Completed responses only’.

It appears that the length of the text answers are longer for the ‘completed responses only’ syntax file, which show full text answers, while the text answers appear to be truncated in the “All responses” SPS file.

However, the truncation does not appear to be consistent across variables. Is this programmed on purpose (i.e. because there is simply a larger volume of data for the ‘All responses’ file, longer text answers are automatically truncated), or is there an error occurring?

LS 2.67.3 build 170728
The topic has been locked.
  • LouisGac
  • LouisGac's Avatar
  • Visitor
  • Visitor
7 years 1 month ago #158838 by LouisGac
Replied by LouisGac on topic SPSS Truncated Responses
I'd say it's a bug.
Could you please a bug report and attach to it a lsa file?
The topic has been locked.
  • blocka
  • blocka's Avatar Topic Author
  • Offline
  • Platinum Member
  • Platinum Member
More
7 years 1 month ago #158905 by blocka
Replied by blocka on topic SPSS Truncated Responses
I've reported as bug : bugs.limesurvey.org/view.php?id=12697

I'm willing to fund fixing this if we can expedite it, as it is causing us a major problem with our data analysis.
The topic has been locked.
  • blocka
  • blocka's Avatar Topic Author
  • Offline
  • Platinum Member
  • Platinum Member
More
7 years 1 month ago #158951 by blocka
Replied by blocka on topic SPSS Truncated Responses
I added this information to the bug report, but then wondered if maybe it isn't a bug, and instead is correct behaviour?

I notice that the syntax file for Complete Only and Incomplete Only contain different values. I've attached a comparison of the relevant parts of the SPS file (that are different).

Is there an explanation for the differences?
Attachments:
The topic has been locked.
More
7 years 1 month ago #159227 by Payek
Replied by Payek on topic SPSS Truncated Responses
Hi, blocka,
I'm sure it's not your desired answer, but I had the same problem. Probably (it's visible in your comparison pdf) length of text variables for "Completed responses only" is miscalculated. So, you have a few options how to handle with this.
1. Export all responses from Lime, import them to SPSS and remove all not finished (with an empty variable "Submit date").
2. Export from Lime syntax (.sps) file for "All responses" and data file (.dat) for "Completed responses"
3. If in your survey is just a few open text questions, you can edit syntax file (.sps) and change manually length of text variables (A is text variable, number behind A is a length. For example V54 A45 to V54 A200). In most of my surveys, it is the easiest way.
The topic has been locked.
  • blocka
  • blocka's Avatar Topic Author
  • Offline
  • Platinum Member
  • Platinum Member
More
7 years 1 month ago #159230 by blocka
Replied by blocka on topic SPSS Truncated Responses
@Payek thanks for the input!

Yes, you are right, it is a "bug" -- and Denis Chenu @ sondages.pro has provided me with a patch, which I think is being submitted to LS core for consideration.
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team & Official Partner
  • LimeSurvey Community Team & Official Partner
More
7 years 1 month ago #159237 by DenisChenu
Replied by DenisChenu on topic SPSS Truncated Responses
Yes : patch is here : github.com/LimeSurvey/LimeSurvey/pull/815 .

But still have a potential issue with 'Array (number)' question type. Please : if it's fix your issue : put it on githb (in a comment)

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member. - Professional support - Plugins, theme and development .
I don't answer to private message.
The topic has been locked.
Moderators: tpartnerholch

Lime-years ahead

Online-surveys for every purse and purpose