Already a member?

Sign In

Tools for extracting ASCII data and DDI metadata from Stata, SPSS, and other proprietary statistical file formats

Presenter 1
Andrew DeCarlo
Metadata Technology North America

Statistical data are often stored in proprietary files formats such as SAS, Stata, SPSS, and others. While useful for processing and analytical purposes, it makes it challenging to access unless you have the right software or utility, which often requires commercial licensing. While statistical packages are not particularly metadata aware, these files hold a significant amount of variable level information. Having the ability to extract these in a DDI friendly XML format along with complementing it with summary statistics computed off the data, is highly desirable. Extending on previous efforts, Metadata Technology North America has enhanced and developed new Java based packages for reading Stata and SPSS files that can export the data in ASCII text format and extract variable level DDI-Codebook and DDI-Lifecycle metadata (data dictionary and summary statistics). Various options are available in terms of ASCII flavors and metadata generation, providing features beyond what is typical export capabilities of statistical packages or utilities. This enables the conversion of data files into open format combining ASCII+DDI, fit for long term preservation, dissemination, or further processing by DDI aware tools. Our presentation will provide an overview of these utilities, describe use cases, share lessons learned, and discuss future development.

Presentation File: 
  • IASSIST Quarterly

    Publications Special issue: A pioneer data librarian
    Welcome to the special volume of the IASSIST Quarterly (IQ (37):1-4, 2013). This special issue started as exchange of ideas between Libbie Stephenson and Margaret Adams to collect


  • Resources


    A space for IASSIST members to share professional resources useful to them in their daily work. Also the IASSIST Jobs Repository for an archive of data-related position descriptions. more...

  • community

    • LinkedIn
    • Facebook
    • Twitter

    Find out what IASSISTers are doing in the field and explore other avenues of presentation, communication and discussion via social networking and related online social spaces. more...