1 / 32

NC1030 Meeting Panel Data & Codebook Considerations Sharon Danes & Katie Brewton October 18, 2009

NC1030 Meeting Panel Data & Codebook Considerations Sharon Danes & Katie Brewton October 18, 2009. Outline. 1. Overview of 2007 Data Collection Data and Codebook Dated 8-25-09 Filters for Various Subsamples Tool for Longitudinal Analysis. Overview. Overview.

mmerrick
Download Presentation

NC1030 Meeting Panel Data & Codebook Considerations Sharon Danes & Katie Brewton October 18, 2009

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. NC1030 MeetingPanel Data & Codebook ConsiderationsSharon Danes & Katie Brewton October 18, 2009

  2. Outline 1. Overview of 2007 Data Collection • Data and Codebook Dated 8-25-09 • Filters for Various Subsamples • Tool for Longitudinal Analysis

  3. Overview

  4. Overview • The 2007 study was designed to obtain updated information about the status of businesses and owning families and also to learn about the impact of natural disasters and disaster relief on business viability

  5. 1997 HM & BM = 414 Combination=259 BM only = 35 --------------------------- Total = 708 Road Map *NFBS Wave 3 The population for the 2007 survey consisted of the 708 households with business data in 1997 339 cases were screened in 2007 193 Businesses were open/owned/managed 177 Main interview completed 16 Verified status only 11 Businesses open but have no other info. 116 Businesses were closed 97 Screener A, B, or C completed 19 Verified status only 19 Businesses were open but change in ownership or management 13 Screener A, B, or C completed 3 Main interview completed 3 Verified status only 369 cases were not screened in 2007 80 Refused (approx. 22%) 285 Couldn’t be reached (approx. 77%) 77 Maximum calls 208 Unlocatable 4 Health Problems (approx. 1%)

  6. Overview cont. • Methodology Tree (see handout)

  7. Overview cont. NEW table based on discussions with ISU* OLD table from p.7 of ISU Methodology Report* *See handout

  8. Overview cont. • Explanation of differences between the tables • 13 cases were taken from business closed/not owned, screener A, B, or C completed and added to business open but change in ownership/management, screener A, B, or C completed • 5 cases not eligible (deceased) were taken from cases not eligible and added to business closed, verified status only • 3 cases were taken from business closed/not owned, verified status only and added to business open but change in ownership/management, verified status only • 3 cases were taken from business open/owned/managed, main interview completed and added to business open but change in ownership management, main interview completed

  9. Data and CodebookAugust 25, 2009 Version

  10. Data and Codebook • 268 variables in the panel data set are 2007 variables, and they are located on pp. 154-185 of the codebook

  11. Data and Codebook cont. • Screener (pp. 154-160) • Business Survival and Ownership/Management Status, Success • Disaster Questions • Worldview Questions • Interview (pp. 161-178) • Business Demographics • Business Finances • Disaster Questions • Worldview Questions • Conflict and Tension • Imputed Variables (p. 178) • Computed Variables (pp. 179-185)

  12. Data and Codebook cont. • Computed 2007 variables have been added to the data set and codebook • Dispo07 (p.179) • Open07 (p.179) • Combination (interview + screener) disaster variables (pp.183-185)

  13. Screener Variable p.157 Interview Variable p.166 Combination Variable p.184

  14. Filters

  15. Filters *Filter to get 339 businesses screened in 2007. USE ALL. COMPUTE filter_$=(dispo07=5 or dispo07=6 or dispo07=7 or dispo07=8 or dispo07=9 or dispo07=10 or dispo07=11 or dispo07=12). VARIABLE LABEL filter_$ 'dispo07=5 or dispo07=6 or dispo07=7 or dispo07=8 or dispo07=9 or dispo07=10 or dispo07=11 or dispo07=12 (FILTER)'. VALUE LABELS filter_$ 0 'Not Selected' 1 'Selected'. FORMAT filter_$ (f1.0). FILTER BY filter_$. EXECUTE .

  16. Filters cont. *Filter to get the 282 businesses for which a screener or interview was completed by a business or combo manager in 2007 – Note that we removed the 8 household managers in compty07 (see next slide). USE ALL. COMPUTE filter_$=((dispo07=5) or (dispo07=10) or (dispo07=8 and compty07 ne 6) or (dispo07=11 and compty07 ne 6)). VARIABLE LABEL filter_$ '(dispo07=5) or (dispo07=10) or (dispo07=8 and compty07 ne 6) or (dispo07=11 and compty07 ne 6) (FILTER)'. VALUE LABELS filter_$ 0 'Not Selected' 1 'Selected'. FORMAT filter_$ (f1.0). FILTER BY filter_$. EXECUTE.

  17. Filters cont.

  18. Filters cont. • Disaster Tree (see handout)

  19. Filters cont. *Filter to get the 172 businesses for which an interview was completed by a business or combo manager in 2007 – Note that we removed the 8 household managers in compty07 (see next slide). USE ALL. COMPUTE filter_$=((dispo07=8 or dispo07=11) and (compty07 ne 6)). VARIABLE LABEL filter_$ '(dispo07=8 or dispo07=11) and (compty07 ne 6) (FILTER)'. VALUE LABELS filter_$ 0 'Not Selected' 1 'Selected'. FORMAT filter_$ (f1.0). FILTER BY filter_$. EXECUTE.

  20. Filters cont.

  21. Filters cont. *Filter to get the 144 businesses in which the business was open, the business had the same owner/manger, and where there was complete information provided in 1997, 2000, and 2007. USE ALL. COMPUTE filter_$=((finals00=1 and dispo07=8)). VARIABLE LABEL filter_$ ' (finals00=1 and dispo07=8) (FILTER)'. VALUE LABELS filter_$ 0 'Not Selected' 1 'Selected'. FORMAT filter_$ (f1.0). FILTER BY filter_$. EXECUTE.

  22. Filters cont. *Filter to get the 77 combination manager households from the 180 businesses that were open and had complete information in 2007. USE ALL. COMPUTE filter_$=((compty07=1 or compty07=2 or compty07=3)). VARIABLE LABEL filter_$ '(compty07=1 or compty07=2 or compty07=3) (FILTER)'. VALUE LABELS filter_$ 0 'Not Selected' 1 'Selected'. FORMAT filter_$ (f1.0). FILTER BY filter_$. EXECUTE.

  23. Filters cont. *Filter to get the 103 single manager households from the 180 businesses that were open and had complete information in 2007. USE ALL. COMPUTE filter_$=((compty07=4 or compty07=5 or compty07=6)). VARIABLE LABEL filter_$ '(compty07=4 or compty07=5 or compty07=6) (FILTER)'. VALUE LABELS filter_$ 0 'Not Selected' 1 'Selected'. FORMAT filter_$ (f1.0). FILTER BY filter_$. EXECUTE.

  24. Filters cont. *Filter to get the 86 couples with complete information in 2007. USE ALL. COMPUTE filter_$=(compls97=1 and h2bre297=2 and h2cse197=1 and h2cse297=0 and id1 ne 2165 and id1 ne 13961 and compty07=4). VARIABLE LABEL filter_$ 'compls97=1 and h2bre297=2 and h2cse197=1 and h2cse297=0 and id1 ne 2165 and id1 ne 13961 and compty07=4 (FILTER)'. VALUE LABELS filter_$ 0 'Not Selected' 1 'Selected'. FORMAT filter_$ (f1.0). FILTER BY filter_$. EXECUTE.

  25. Tool for Longitudinal Analysis • Map of Variables

  26. Additional Data and Codebook Information • SHELDUS (p.186) • PERI (p.190) • County Business Patterns (p.192) • Socioeconomic Vulnerability Index (p.192)

  27. Questions?

More Related