Unable to merge spss data sets obtained through exportation from ONA

[dove djossaya]

Dear Sir,

Great is my pleasure to have been able to join this platform. I exported data in spss format using ONA. Two separate data sets were created. The first was automatically named repeat, that contains data for repeated questions, while the second had only data for single questions. I'd like to know how I can merge these two data sets in order to perform some analysis.

Regards.

Dove.

NB.The 2 spss data sets are attached (.sav). 

[Megan from Ona]

This message was sent to the following 2 people: dove djossaya, ona-co...@googlegroups.com. Replying to this email will notify them.

Hello Dove, Kindly note that your data comes in different sheets when you select Excel or SAV as your export format. The number of sheets is equivalent to the number of repeat groups in your form. To merge the different sheets, we would recommend that you use the parent_index column and match it with the  _index column in Sheet1 (parent data). Then, you can use index match (Vlookup) to match all the pulled parent data to the other sheets using the _index as the unique ID.  An alternative would be to export the data as CSV. All the data is exported in one worksheet with each column following the order of the questionnaire. Please let us know if you have further questions. Regards, Megan See our community forum & help site for more information!

-- Megan from Ona

-- Collect, Analyze and Share Data - https://ona.io/ --- You received this message because you are subscribed to the Google Groups "Ona Community" group. To unsubscribe from this group and stop receiving emails from it, send an email to ona-communit...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/ona-community/f08fa09b-641d-4a7b-9a2f-a45d309e127b%40googlegroups.com. Repeatc.sav Sierra_Leone_2019_MR_Survey_V2c.sav

[dove djossaya]

Hi Megan,

I managed to merge the 2 spss data sets by renaming the parent_index into _index . The next issue here is that values for the different cases appear once and I'm oblige to copy and paste in order to fill the missing values. if this could be done automatically in spss, it will be time saving. Any advice?

Best wishes for 2020.

Dove.

NB. My choice for using spss is to keep the value labels and value sets for each of the questions.

   

To view this discussion on the web visit https://groups.google.com/d/msgid/ona-community/8f86b62f-94cb7757-1577968974-25226676319%40ona.intercom-mail.com.

[Megan from Ona]

This message was sent to the following 2 people: dove djossaya, ona-co...@googlegroups.com. Replying to this email will notify them.

Hello Dove, Glad to hear you were able to resolve your issue! However, the way the data is formatted in the repeat group is a row for each repeat group of questions answered. This means if one record had more than one repeat group of questions, this type of merge would be one record merged to many records resulting in multiple rows per record.  Unfortunately, there is not a way to change how the data is exported in the repeat group sheet. The only alternative is to export as a CSV, but this will not include the value labels and value sets as you indicated you would like. I don't think there is simple way to do this. I would recommend checking the SPSS support forums: https://developer.ibm.com/predictiveanalytics/forums/

Regards, Megan See our community forum & help site for more information!

-- Megan from Ona

On Thu, Jan 2, 2020 at 04:52 PM, "dove djossaya" <djossa...@gmail.com> wrote:

Hi Megan, I managed to merge the 2 spss data sets by renaming the parent_index into _index . The next issue here is that values for the different cases appear once and I'm oblige to copy and paste in order to fill the missing values. if this could be done automatically in spss, it will be time saving. Any advice? Best wishes for 2020. Dove. NB. My choice for using spss is to keep the value labels and value sets for each of the questions.

On Thu, Jan 2, 2020 at 03:42 PM, "Megan" <me...@ona.intercom-mail.com> wrote:

Hello Dove, Kindly note that your data comes in different sheets when you select Excel or SAV as your export format. The number of sheets is equivalent to the number of repeat groups in your form. To merge the different sheets, we would recommend that you use the parent_index column and match it with the  _index column in Sheet1 (parent data). Then, you can use index match (Vlookup) to match all the pulled parent data to the other sheets using the _index as the unique ID.  An alternative would be to export the data as CSV. All the data is exported in one worksheet with each column following the order of the questionnaire. Please let us know if you have further questions. Regards, Megan See our community forum & help site for more information!

On Wed, Jan 1, 2020 at 06:07 PM, "dove djossaya" <djossa...@gmail.com> wrote:

Dear Sir, Great is my pleasure to have been able to join this platform. I exported data in spss format using ONA. Two separate data sets were created. The first was automatically named repeat, that contains data for repeated questions, while the second had only data for single questions. I'd like to know how I can merge these two data sets in order to perform some analysis. Regards. Dove. NB.The 2 spss data sets are attached (.sav). -- Collect, Analyze and Share Data - https://ona.io/ --- You received this message because you are subscribed to the Google Groups "Ona Community" group. To unsubscribe from this group and stop receiving emails from it, send an email to ona-communit...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/ona-community/f08fa09b-641d-4a7b-9a2f-a45d309e127b%40googlegroups.com. Repeatc.sav Sierra_Leone_2019_MR_Survey_V2c.sav