Try Out New (and Free) Software for Variable Recoding and Harmonization: QuickCharmStats 1.1 and CharmStats Pro 1.0

Guest post by Dr. Kristi Winters, CharmStats Project Manager, GESIS Data Archive for the Social Sciences

Do you have variables to harmonize for statistical analysis or as part of a large scale study’s data preparation and documentation? There are new, free, and open-source software solutions available that can speed the process of variable harmonization as well as preserve variable-, question- and study-level metadata for you. These programs generate harmonization syntax in multiple statistical languages and generate reports or even codebooks to quickly publish your work in a readable format.

The first product is designed for small scale research (under 100 variables to be harmonized) such as publishing an article or producing a report. QuickCharmStats (QCS) was designed to reduce the time and effort researchers spend harmonizing and recoding variables in preparation for statistical analysis. The second product, CharmStats Pro was designed for larger research projects and for national and international research teams to centralize, document and process the harmonization documentation process.


mint-quick-charmstats-javaQuickCharmStats 1.1 (QCS) was designed for researchers who want to quickly and easily create recoding syntax for use in statistical analysis. It allows you to import the necessary metadata information from SPSS and Stat/Transfer. Once the metadata are imported you can search for the variables you need, import them into your project and quickly produce the syntax you need to harmonize variables in SPSS and Stata.

QCS 1.1 has two further features: Reports and Graphs. The report feature allows you to choose from Templates and instantly create an .html file based on the information and metadata in your project. Save your documentation and bibliographical information, your notes with information on your coding decisions, as well as the harmonization syntax. Share your report with others at anytime, anywhere, or to post it online as a reference. The graph feature provides an image of your harmonization.  These can be saved as .jpegs and used in presentations or included as part of your documentation.

CharmStats Pro

charmstats-pro-javaCharmStats Pro is for those large study researchers or survey teams who want to quickly and easily create and preserve the recoding or harmonization syntax as part of a codebook. CharmStats Pro imports the necessary metadata information to document the harmonizations. Once imported, researchers can search for the variables you need, import them into a project and quickly produce syntax(es) to harmonize variables in SPSS and Stata. This version also allows research teams to add reference information for any sources consulted. CharmStats Pro auto-generates the same reports and graphs found in QuickCharmStats 1.1, for all your documentation needs.

CharmStats Pro is unique because it allows for a shared database that connects all the members of a study team. Those who work on large-scale studies or research projects with several staff can now combined and collaborate on their variable harmonization and documentation work.  To facilitate a cooperative digital environment, CharmStats Pro has a communications suite featuring an internal email and task manager system to help teams organize their work.

We believe that after investing a short amount of time learning how to create projects you and your team will save valuable time and effort by digitizing your harmonization work. Learn more on how to get your original documentation work published for citation by reading this open access article on harmonization documentation standards and reporting:

To contact us or download the software, please visit