When we extract data from a very complex survey with multiple repeated groups, the repeated information is blocked in the data via URL linkages to HTML table files. How might we write code to extract this information automatically into SAS?
Use ODK Briefcase to pull the data from the server to your local computer.
Then use Export CSV within ODK Briefcase to generate a CSV file for each
survey and every repeat group within the survey.
The PARENT_KEY field in the repeat group will correspond to the KEY in the
enclosing repeat group or survey.
Alternatively, if you do not have nested repeat groups, you can publish to
Fusion Tables and we will create a flat view of the data, with the
top-level survey row repeated alongside every repeat group. I.e., if you
had a survey with 2 independent repeat groups, and filled in such a survey
with 2 instances of each repeat, you would end up with 2x2 = 4 rows in this
top-level view. You could then export that and import it into SAS. This
can also be used for nested repeat groups -- we simply did not write the
complex logic needed to flatten that type of a survey, but Fusion Tables is
fully suited to support such a construction.
On Wed, Mar 11, 2015 at 5:42 AM, wrote:
When we extract data from a very complex survey with multiple repeated
groups, the repeated information is blocked in the data via URL linkages to
HTML table files. How might we write code to extract this information
automatically into SAS?
You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to firstname.lastname@example.org.
For more options, visit https://groups.google.com/d/optout.
University of Washington