Prepare Data

1. Download the dataset setup files from UC-UTCC Dataverse. Please follow UC-UTCC Dataverse user guide. Any question about UC-UTCC Dataverse, please contact Dataverse support email: rapeepong@dvn.utcc.ac.th

 

2. Please read and understand term of use before downloading each dataset. If you accept the term of use, make a checkbox “I agree and accept these terms of use” checked and click Continue button. Or not, click Cancel button.

3. Click Save button on the file download dialog box. And select the directory to save this file.

Figure 3 Save dataset setup file to local computer.

4. After downloading, you have to decompress the dataset setup files in your local computer. Figure 4 is just one of several ways to extract zip file in local computer. You can choose other solutions to extract file if you cannot follow this figure.

In Figure 4, we extract downloading file on the C drive.
5. Some dataset has a large size. So we have to separate the dataset into several parts. You don’t need to import all parts in SPSS. Just import the interesting part to SPSS for use.
For each part or dataset, there are many setup files and 1 ASCII data file. For SPSS, we use only 2 files.
• A columnar ASCII data file (.txt)
• A SPSS syntax file (.sps)

Figure 5 Setup file for National Rural Development 2005 Part 1

 

In Figure 5, we use these below files to import National Rural Development 2005 Part 1 (NRD2005 Part 1) to SAS. The path for reference is C:\NRD2005_setup_file\NRD2005_PART1
• NRD2005_PART1_DATA.txt
• NRD2005_PART1_setupSPSS.sps

Import data to SPSS

1. Open SPSS for Windows. If a dialog box SPSS for Windows open, close it by clicking the Cancel button.

 
2. Open the SPSS setup file in the SPSS for Windows Syntax Editor.
    Click on File -> Open -> Syntax.

Figure 7 Open SPSS for Windows Syntax Editor

3. Select the SPSS setup file in File Dialog box.
• Look in: Choose the path where the SPSS setup file is located.
• File of type: Set type to Syntax (*.sps).
• File name: Click on the SPSS setup file. The name will appear after file name.
• Click Open button for open the SPSS setup file.

Figure 8 Open SPSS setup file
 

In Figure 8, we choose the SPSS setup file of National Rural Development 2005 Part 1 (NRD2005_PART1_setupSAS.txt). The path is C:\NRD2005_setup_file\NRD2005_PART1

4. SPSS will display the file in the SPSS Syntax Editor.

Figure 9 SPSS Syntax Editor

5. Enter the full path and name of the raw ASCII data file in SPSS Syntax Editor.
• FILE HANDLE DATA -- Enter the full path and name of the raw ASCII data file.

Figure 10 Enter the full path of the data file
 

In Figure 10, we enter the full path and name of the raw ASCII data file for the National Rural Development 2005 Part 1. Commands should read:
FILE HANDLE DATA ‘C:\NRD2005_setup_file\NRD2005_PART1\NRD2005_PART1_DATA.txt’;

6. After editing the path, click on Run -> All to run command. The data will import to SPSS program.

Figure 11 Run command

7. After submit command, data will import to SPSS program. You can see detail of the dataset in SPSS Output.

Figure 12 SPSS Output
 

8. When the processor is finished, Click on menu Window -> SPSS Data Editor to see the data.

Figure 13 SPSS Data Editor

9. You can see data in SPSS Data Editor. Now data can be ready for analysis in SPSS.

Figure 14 SPSS Data Editor 

Reference

http://www.icpsr.umich.edu/cocoon/SAMHDA/FAQ/0056.xml
http://www.icpsr.umich.edu/cocoon/SAMHDA/FAQ/0061.xml
http://www.icpsr.umich.edu/cocoon/SAMHDA/FAQ/0062.xml
http://www.icpsr.umich.edu/cocoon/SAMHDA/FAQ/0127.xml

Author: Sirivimol Thanchalatudom
Reviewer: Phongkiat Koopkan