SPSSOMS2DDI
A tool to generate variable-level metadata for DDI documents from SPSS files.
With this tool it is possible to generate the basic variable documentation
for the data description part of a DDI
document on the basis of SPSS
files (see DDI description of variable
and category).
It generates:
- For each variable: variable name, variable label (if available), and common descriptive statistics.
- For each category: category value, category label (if available), frequencies, and percentage.
Two steps are necessary to get a valid DDI document:
- Creation of an intermediary XML file in the SPSS OMS XML format by running a SPSS command setup.
- XSL transformation of this SPSS OMS XML file by a XSL style sheet into a XML file according to the DDI
standard.
What is SPSS OMS? OMS is an output management system of SPSS since version 12.0. OMS provides syntax-driven control over SPSS output. Besides other formats OMS can create XML files. These XML files have a structure according to the
XML schema of SPSS.
From the SPSS file "study.sav" the SPSS command setup "spss_oms.sps" generates the OMS XML output file "study_spssoms.xml" (example). SPSS commands could be run in a syntax window of SPSS or by the SPSS production facility with "spssprod -r spss_oms.spp". The file names and the study title must be configured prior to running the commands. A XSL processor transforms according the style sheet "spssoms2ddi.xsl" the OMS XML file into the DDI XML file "study_ddi.xml" (example).
SPSSOMS2DDI is licensed under the terms of the GNU General Public License.
Download the zipped files (version 2004-05-12).
To-do list:
- Variable level: location, variable range, missing values, weighted results for descriptive statistics.
- Category level: weighted frequencies and percentage, missing value indicator.
© GESIS Joachim Wackerow
2006-01-31