1 / 14

Using Stata as a Computation/Estimation Companion in a Relational Database Environment

Using Stata as a Computation/Estimation Companion in a Relational Database Environment.

donkor
Download Presentation

Using Stata as a Computation/Estimation Companion in a Relational Database Environment

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Using Stata as a Computation/Estimation Companion in a Relational Database Environment Abstract:Stata can be used as a companion to relational database software to compute and serve up information for live public use. We demonstrate how a Microsoft Access database of electoral data calls up Stata .do files to compute and/or estimate alternative measures of political party “nationalization.” More generally, where data reside live and for broad public consumption, Stata can play a valuable role operating behind the scenes for non-technical users where measures of conceptual value cannot be generated from within the database environment. Tom Mustillo, tmustill@iupui.edu Department of Political Science Indiana University Purdue University-Indianapolis Sarah Mustillo, smustill@purdue.edu Department of Sociology Purdue University MS Access + Stata 1. The Database 2. The Problem 3. The Interaction 4. A Demo 5. Issues

  2. Agenda • The Electoral Database • The Problem • The Stata/Access Interaction • A Demonstration • Outstanding Questions/Issues MS Access + Stata 1. The Database 2. The Problem 3. The Interaction 4. A Demo 5. Issues

  3. 1. The Electoral and Institutional Database of the World • The Contents • The Audience • A Dynamic System • Computing measures of conceptual value • Party Nationalization: Distribution of a political party’s voter support over the geographic units of the territory. • Party Nationalization Score (Jones and Mainwaring 2003) • Components of Variance (Morgenstern and Potthoff 2005) MS Access + Stata 1. The Database 2. The Problem 3. The Interaction 4. A Demo 5. Issues

  4. 2. The Nature of the Problem • Translating electoral results into nationalization • The limited range of available functions • 2 Measures of Nationalization • Party Nationalization Score(1-GINI): .egengini=inequal(Vote%), by(Province Election) • Components of Variance. by Party: xtmixed Vote% || _all: R.Province || _all: R.Election, var MS Access + Stata 1. The Database 2. The Problem 3. The Interaction 4. A Demo 5. Issues

  5. 3. The Stata/Access Interaction • Access as the user interface • On “Nationalization” measures, Access … • i. selects and exports data • ii. calls up Stata .do file • iii. imports and serves up the result MS Access + Stata 1. The Database 2. The Problem 3. The Interaction 4. A Demo 5. Issues

  6. 4. A Demonstration of the Applications MS Access + Stata 1. The Database 2. The Problem 3. The Interaction 4. A Demo 5. Issues

  7. 5. Outstanding Questions/Issues • Licensing • Alternative database-Stata mechanisms • Performance • Timing • Web environment MS Access + Stata 1. The Database 2. The Problem 3. The Interaction 4. A Demo 5. Issues

  8. Using Stata as a Computation/Estimation Companion in a Relational Database Environment Abstract:Stata can be used as a companion to relational database software to compute and serve up information for live public use. We demonstrate how a Microsoft Access database of electoral data calls up Stata .do files to compute and/or estimate alternative measures of political party “nationalization.” More generally, where data reside live and for broad public consumption, Stata can play a valuable role operating behind the scenes for non-technical users where measures of conceptual value cannot be generated from within the database environment. Tom Mustillo, tmustill@iupui.edu Department of Political Science Indiana University Purdue University-Indianapolis Sarah Mustillo, smustill@purdue.edu Department of Sociology Purdue University MS Access + Stata 1. The Database 2. The Problem 3. The Interaction 4. A Demo 5. Issues

  9. US 2004 Republican Presidential, GINI, County-Level, GINI=.11699

  10. MS Access + Stata 2. EIDW PNS Illustrated (Actual):Strongly Nationalized Support US 2004 Republican Presidential Votes, by County PNS = .88

  11. MS Access + Stata 2. EIDW PNS Illustrated (hypothetical):Completely Nationalized Support US Votes, by County PNS=1.0

  12. PNS Illustrated (hypothetical):Completely Nationalized Support US Votes, by County MS Access + Stata 2. EIDW PNS=1.0

  13. PNS Illustrated: Strongly Localized Support (PNS 0)South African Votes, by Province MS Access + Stata 2. EIDW South Africa, 2004 Inkatha Freedom Party 34% of the vote in KwaZulu-Natal <1% almost everywhere else

  14. PNS Illustrated: Strongly Localized Support (PNS 0)UK Votes, by District MS Access + Stata 2. EIDW United Kingdom, 2005 Sinn Fein Strong in N. Ireland Weak elsewhere

More Related