Getting Data for Small Areas: Example of Regency of Bangli in the Province of Bali, Indonesia Census Samples

1. https://international.ipums.org/international • How to get data for small areas: • Example: Regency of Bangli in the province of Bali, from the 2010 and 2000 census samples of Indonesia • Login • Browse and Select Data • Select samples: Indonesia 2000 & 2010 • Select variables (include Regency, RGCYID) • Select cases: = “Bangli” • Submit extract request • Download extract to your computer • Analyze data using your statistics software For this and other tutorials:http://www.hist.umn.edu/~rmccaa/IPUMSIclick “tutorials” (in left frame)

2. 1. Login: a. click “Login” on home page b. Click “Login” on registration page c. Submit registered email address & password

3. Click “Select Data” Note: to revise a prior extract, click “Saved Extracts” Click “Select Data”.Note: to revise a prior extract, click “Saved extracts”

4. 2a. Integrated Metadata: Variables Menu First, click here, to select samples (the default is “all samples in the database”) Only start here if you wish to see variables for all samples

5. 2b. Select Samples: Scroll down to Indonesiaclick years and “submit sample selections” Scroll down to “Indonesia” Click “2010” and “2000” boxes to select samples for these censuses.

6. Step 3a. Select Variables: Mouse-over “Household”, then click “Geography” Mouse-over household for drop down menu, then click “Geography”

7. Step 3b. Select variables, including RGCYID (Regency, Indonesia) Click box beside “RGCYID” to select “Regency, Indonesia” variable for cart Click “Codes” to view a list of the regencies in “RGCYID”

8. 3c. After RGCYID, select other variables, When finished selecting variables, Click “View Cart” to go to next step.

9. Step 3d. Review selections. Add/remove variables/samples. Click “Create data extract”

10. Step 4. Customize Extract:“Data format” and “Select Cases” Click here to select cases (by RGCYID).

11. Step 4a. Select cases: select the variables which will be used to select cases. Here we chose “RGCYID” Click here, to select persons by Regency of residence

12. Step 4b. Select Bangli, the Regency to study, and click “Submit” Standard mouse conventions apply. To make more than one selection, hold <ctrl> and press left mouse button.

13. Step 5a. Submit extractOptional: Data Format, Description, etc. Click here to select SPSS, SAS, or STATA format Describe the extract to make it identifiable to you. If someday you wish to revise it, you may recall what the extract is about.

14. Optional, prior screen: “change” data formatMake choice here and click “Submit” Select a preferred data format: STATA, SPSS, SAS, cvs or the default: fixed solumn width

15. Step 5b. Extract confirmation. Wait for email to download extract. Note: Once the extract is confirmed, Data Cart is now emptied.

16. 6a. Email notification to retrieve extract (< 4 minutes). Click the link and login. Note: For citation, acknowledge both MPC and the statistical office that provided microdata

17. Step 6b. Click to download extract and metadata (“DDI”, basic or command files). Note: Click “SPSS” to download system file. Also download metadata and fixed column data, as desired.

18. Step 7. Unzip and analyze 10% sampleWould a 1% sample suffice to analyze Bangli? Is there gender discrimination in education in Bangli? (some)Is the female disadvantage decreasing over time? (yes)Policy: most critical need is to improve educational access for all.

19. https://international.ipums.org/international • How to get data for small areas: • Example: Regency of Bangli in the province of Bali, from the 2010 and 2000 census samples of Indonesia • Login • Select samples (Indonesia 2000 & 2012) • Select variables (include Regency, RGCYID) • Select cases: = “Bangli” • Submit extract request • Download extract to your computer • Analyze data using your statistics software For this and other tutorials:http://www.hist.umn.edu/~rmccaa/IPUMSIclick “7 tutorials”