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.
It is a tool which enables easy anonymization processes of DDI standard univariate statistics. It was developed primarily to address the issue of statistical disclosure control for single variable aggregated data, publically distributed to particularly provide information to scientific researchers to promote detailed official statistics microdata use for scientific purposes. It enables quick and easy automatic data protection by performing data protection methods such as bracketing, top- and bottom-coding, variable (information) removal, numeric descriptive statistics protection and low frequency protection following the minimum frequency rule. In contrast to existing microdata and aggregated data anonymization tools, the developed software protects aggregated data directly in the XML code.
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.
Developed by the Data Archive of GESIS, this tool imports SPSS data files; allows documentation of questions, sub-questions and answers; enables language-specific documentation; shows two languages concurrently on the screen; permits reuse of question documentation; exports into a DDI 2-compatible format, for Nesstar or long-term preservation; and exports into a DDI 3-compatible format, supporting enhanced publications.
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.