150 likes | 218 Views
WinDEM - Merge Files. Purpose of this Presentation. Merge WinDEM Data Files. When is it neccessary? How can it be done technically? What has to be taken into account?. 2. Merge WinDEM Data Files. Example: Imagine you have entered some students' questionnaire data of your country
E N D
Purpose of this Presentation Merge WinDEM Data Files • When is it neccessary? • How can it be done technically? • What has to be taken into account? 2
Merge WinDEM Data Files • Example: Imagine you have entered some students' questionnaire data of your country in two different files: 3
Puncher ID 111 Puncher ID 222 Merge WinDEM Data Files WinDEM File (ISGDEUF2.dbf) WinDEM File (ISGNATF2.dbf) 4
Puncher ID 222 Puncher ID 111 Merge WinDEM Data Files WinDem File (ISGDEUF2.dbf) 5
NOTE: Merge WinDEM Data Files • Merging data files is only neccessary if you entered the same type of data in more than one data file. • Merging data files should be done before final data cleaning. 6
Merge WinDEM Data Files Sidebar How to open the Table View? 7
NOTE: The codebooks corresponding to the files must have exactly the same structure. Merge WinDEM Data Files All students from school 8001 (main file) ISGDEUF2.dbf ISGNATF2.dbf (file to be merged) All students from school 8502 8
Merge Data Files – Process • To merge two data files in WinDEM, you need to open the CODEBOOK of the first (main) file: ISGDEUF2.sdb 9
Merge Data Files – Process • Please select a codebook with a corresponding data file in the appropriate path. • You will get a message that informs you about the already existing data file. • Click „OK“ to proceed. 10
Merge Data Files – Process • Select Import > WinDEM from the “Import/Export” menu • Open the data file to be merged 11
Merge Data Files – Result • The records from ISGDEUF2.dbf and ISGNATF2.dbf have been merged now. • The merged data file will automatically take the name of the open codebook (in our example ISGDEUF2.dbf). The data file ISGDEUF2.dbf now consists of 15 records (8+7). 12
Merge Data Files – Result • Once you have merged the files, the combined data file (main file) will appear as follows: Records from main file (ISGDEUF2.dbf) Records from imported file (ISGNATF2.dbf) 13
NOTE: Merge Data Files If you want to keep a copy of the original file (here: ISGDEUF2.dbf), save it (and its codebook) under a different name BEFORE you perform data merging! Although you may have checked the individual files BEFORE merging and no problems were found, it is recomended that you repeat the check on duplicated records (Unique ID check) for the merged file! 14
Thank you! 15