- Posts: 2
- Thank you received: 0
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
Array (Numbers): coding No answer vs. 0 in export
- FReith
- Topic Author
- Offline
- New Member
Less
More
5 years 1 month ago #180587
by FReith
Array (Numbers): coding No answer vs. 0 in export was created by FReith
Dear forum,
I have an array(numbers) question with restrictions on the numerical fields
Minimum value: - 1
Step value: 1
Maximum value: 3
(i.e. including 0)
The results are different between my statistical software (stata via csv-import or alternatively xml-import) and the LS-statistics tool. I have already found out via the manual that the array(numbers) field is numerical and that the string {no answer} will be stored as NULL.
My question: is there a way to control that NULL will not be exported as the value 0?
Background: I have different frequencies for the answer "0" in the LS-tool and the exported data matrices but I cannot see that the mistake is systematic because the exported data has both zeros (0) and missing values (not answered/not displayed) but the distribution between the zeros and missing values is different in the exported data and LS-statistics.
If this cannot solved in the export, is the coding in the LS-statistics tool reliable?
I work with LS-Version 3.15.9.
Thank you in advance!
Cheers,
Christine
I have an array(numbers) question with restrictions on the numerical fields
Minimum value: - 1
Step value: 1
Maximum value: 3
(i.e. including 0)
The results are different between my statistical software (stata via csv-import or alternatively xml-import) and the LS-statistics tool. I have already found out via the manual that the array(numbers) field is numerical and that the string {no answer} will be stored as NULL.
My question: is there a way to control that NULL will not be exported as the value 0?
Background: I have different frequencies for the answer "0" in the LS-tool and the exported data matrices but I cannot see that the mistake is systematic because the exported data has both zeros (0) and missing values (not answered/not displayed) but the distribution between the zeros and missing values is different in the exported data and LS-statistics.
If this cannot solved in the export, is the coding in the LS-statistics tool reliable?
I work with LS-Version 3.15.9.
Thank you in advance!
Cheers,
Christine
The topic has been locked.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13935
- Thank you received: 2551
5 years 1 month ago #180595
by DenisChenu
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
Replied by DenisChenu on topic Array (Numbers): coding No answer vs. 0 in export
We export null value as an empty string in CSV
Did you use STATA export plugin ?
Did you use STATA export plugin ?
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The topic has been locked.
- FReith
- Topic Author
- Offline
- New Member
Less
More
- Posts: 2
- Thank you received: 0
5 years 1 month ago #180600
by FReith
Replied by FReith on topic Array (Numbers): coding No answer vs. 0 in export
Thank you!
So, just to spell it out and know that I understood correctly: the csv shows the correct matrix, not the LS-statistics tool. Correct?
I used the Stata-plugin but I had some troubles with it or more generally, troubles with exporting the data (also in csv).
Survey respondents used line breaks in their free-text answers. LS did not export this as a continued string but started a new line. The dataset is rather large and formatting it by hand in wordpad was not an option. But Stata had a solution for that.
So, just to spell it out and know that I understood correctly: the csv shows the correct matrix, not the LS-statistics tool. Correct?
I used the Stata-plugin but I had some troubles with it or more generally, troubles with exporting the data (also in csv).
Survey respondents used line breaks in their free-text answers. LS did not export this as a continued string but started a new line. The dataset is rather large and formatting it by hand in wordpad was not an option. But Stata had a solution for that.
The topic has been locked.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13935
- Thank you received: 2551
5 years 1 month ago #180602
by DenisChenu
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
Replied by DenisChenu on topic Array (Numbers): coding No answer vs. 0 in export
I don't know if LimeSurvey stat have an issue : need a simple LSS showing this (and best in
bugs.limesurvey.org/my_view_page.php
About CSV : in a real CSV newline can be used.
About STATA export : if export with new line are not read in STATA : must report the issue.
About CSV : in a real CSV newline can be used.
About STATA export : if export with new line are not read in STATA : must report the issue.
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The topic has been locked.