Crosswalk 4.1

CISER has been using Crosswalk 3.0 to create setup files and datasets in various formats for our legacy collection in ASCII format. Through a simple Excel spreadsheet with variable information and location in the ASCII file, we can create outputs in SAS, SPSS, STATA, R, DDI 2.5 Codebook, and DDI 3.2 Study Unit quickly and efficiently. For EDDI 2019, we have created Crosswalk 4.1. In addition to the original features, Crosswalk 4.1 will create DDI 3.2 Resource Package that incorporates variable level metadata and statistics; and create a SQL query that can be used to read the ASCII data and transform it into a database in Postgres.  In this poster we will show examples of the original process and demonstrate Crosswalk 4.1’s capabilities.