Submitted by Kelly Chatain on Wed, 2015-10-14 16:09
Turn your data into open data! SledgeHammer is a powerful tool that facilitates the transofrmation of data across popular proprietary, text, and database formats, and the extraction/generation standards based metadata.
Reading data and extracting metadata from: Stata, SPSS, SAS, DDI+ASCII, Stat/Transfer+ASCII,SQL
Transforming data into ASCII text format (fixed, csv, delimited), with various optimizations
Producing standard metadata from input files. Supported specifications include DDI-Codebook (1.0-2.1 and 2.5), DDI LifeCycle (3.1-3.2), and Triple-SSS (1.1, 2.0)
Computing summary statistics at the variable and category levels for inclusion in DDI or for other purposes. Summary statistics include minimum, maximum, average, standard deviation, count of missing values, weighted and unweighted frequencies
Generating scripts for reading ASCII data into R, SAS, SPSS, Stata, Mathematica Notebook, Berkeley SDA, and various flavors of SQL (MS-SQL, MySql, MonetDB,PostgreSQL,Oracle, Vertica, HSQLDB). The database scripts support the creation of database schemas along with bulk loading of the ASCII data.
Colectica for Microsoft Excel is a free tool to document your spreadsheet data using the open standard for data documentation. Document Variables and Datasets: Colectica allows documenting of Variables, Code Lists, and Data Sets directly from within Microsoft Excel. Metadata is Embedded: Colectica saves your standards-based metadata directly in the Microsoft Excel file. If you email or share your file, the metadata will still be attached. Publish Documentation: Colectica for Excel can generate documentation for your Variables, Code Lists, and dataset in PDF, Word, HTML, and XSL-FO. Import Stata to Excel: Colectica for Excel allows direct importing and documenting of Stata data files, with a file extension .dta. The variable names, labels and code lists in the Stata file will also be imported and added to the stored documentation automatically. Import SPSS to Excel: Colectica for Excel allows direct importing and documenting of SPSS data files, with a file extension .sav. The variable names, labels and code lists in the SPSS file will also be imported and added to the stored documentation automatically. Create DDI-Lifecycle Metadata: Export your data documentation to an XML file in the DDI metadata format, the standard for data documentation. Open and edit it from Colectica Designer, Colectica Express, or other DDI applications.
Colectica Designer is a visual DDI metadata editor and survey questionnaire designer. It interacts with Colectica Repository to provide advanced data management functionality. Colectica Designer complements existing systems by importing and generating various forms of data, documentation, and source code.
Nesstar Publisher is an advanced data management program. It consists of data and metadata conversion and editing tools, enabling the user to prepare these materials for publication and make such resources available to a wider audience. The program allows users to enhance datasets by combining a wide range of catalog and contextual information. Users are given, for example, complete control over the structure of the metadata within internationally recognized data documentation schema, including inserting Web links and URLs that can be viewed within the Nesstar Web client. Nesstar Publisher also allows merging of DDI documents containing markup for different sections of the DDI for the same study. This is especially useful for merging in variable description information generated from SPSS/SAS data definition statements or export files with study descriptions and question text.
Apache XMLBeans packages for DDI 1.0, 1.1, 1.2, 1.2.1, 1.2.2, 1.3, 2.0 and 2.1. XMLBeans is a technology for accessing XML by binding it to Java types. For more information, see http://xmlbeans.apache.org/