SAS syntax script for merging export files

Published: 4 May 2022| Version 1 | DOI: 10.17632/mtd5x49mkc.1


This dataset contains a Statistical Analysis System (SAS, v9.4) syntax script for merging individual export files from DIERS formetric III 4D™, DICAM v3.7Beta or other subsequent versions. DICAM offers more than one hundred parameters to be exported as raw data in a .CSV format. The export is separate for each measurement that was chosen in the menu. Depending on the parameter choice different columns are generated. Based on the parameter settings a specific column distribution results. The filename of the export comprises the subject’s code and the speed in km/h. Stance measures for that reason include 0 km/h in the filename. The SAS syntax script assembles all single exports to one complete raw data table. Since not all characters in the DICAM export are compatible to SAS, the script defines own column headings and labels them accordingly. Consequently, the parameter settings are crucial; otherwise wrong data would be read in. Columns containing the subject’s code and the speed in km/h are imported based on the filename of the former export. Now all kinds of statistical analyses can be applied to a full set of data.


Steps to reproduce

Create necessary folders. Adept the script to own needs. Run the program.


Johannes Gutenberg Universitat Mainz


Syntax, Big Data, Biomechanics of Motion