Understanding the 2000 Data Filters

1. Understanding the 2000 Data Filters Webinar May 12, 2009 1.00pm CST

2. Layout of 2000 variables in the Codebook (5-4-09)_ • Household manager interview variables (pages 74-94) • Business manager interview variables (pages 94-120) • Screener variables (pages120-137) • Computed variables (pages 144-150) e.g., openbu00. • Imputed financial variables (pages151-154) e.g., Gross income

3. Roadmap The total sample size is 708. These are the households from 1997 dataset with data on the business.

4. Out of 708 cases Followed in 2000 N=553 99 closed / 33 still open but with a different BM

5. In 2000 • 421 Still involved in the same open business (without complete information). • 325 business managers still managing same open business (with complete information). • 311 cases where complete info & bus still open and managed by same BM and has HM info • Difference between 325 and 311 is that there are 14 BM only data included in 325.

6. The final syntax file to be used Final Syntax 2000 data filters with Merged var labels 5 8 09.doc

7. Filter to get to n of 325 BM still managing same open business with complete information. • Coms9700>=1& Coms9700<=4 (Completion Status for 1997 interview 1 Both Household and Business Interview 2 Combination Interview 4 Business Interview Only) •  & Openbu00=1 (Bus still open) • & Manbs00=1 (Business Manager or Household Manager Still Manages Business ) • & Finals00=1 (Complete information, business still open/owned/managed ).

8. Filter to get n of 311 cases in 2000 where complete info & bus still open and managed by same business managers and has HM info. • Coms9700 >= 1 & coms9700 < 4 (Completion Status for 1997 interview 1 Both Household and Business Interview 2 Combination Interview 4 Business Interview Only) •  & Openbu00=1 (Bus still open) • & Manbs00=1 (Business Manager or Household Manager Still Manages Business ) • & Finals00=1 (Complete information, business still open/owned/managed ). * Difference between 325 and 311 is that there are 14 BM only data included in 325.

9. Quiz 1 Can you describe the sample based on the following frequency table?

10. N Valid 311 Missing 0 Mean .0836 Frequency Percent Valid Percent Cumulative Percent Std. Deviation .28864 Valid .00 286 92.0 92.0 92.0 1.00 24 7.7 7.7 99.7 2.00 1 .3 .3 100.0 Total 311 100.0 100.0 Positive stress indexStatistics

11. Answer • It describes the positive stress index for 311 Businesses in 2000 where business is still open and managed by the same business managers with complete information and has Household Manager information as well. • Try using N=325 and using a HM variable(e.g., Hzb1b00) . You should get 14 missing! That’s because: Difference between 325 and 311 is that there are 14 BM only data included in 325.

12. Homework Assignment • 1.Get frequencies for businesses followed in 2000 from n of 708 in 1997. Find the total frequencies for the variable ‘whether business comes first’? How many answered ‘yes’ and how many ‘no’?

13. Answer to Qs.1 • Use filter to get N=? ; • Use the filter to get N=533; • Use ? variable to get total frequencies? • Use variable busfirst00 to get total frequencies • N = ?, ‘Yes’=? and ‘No’ = ? • N = 553, ‘Yes’=135 and ‘No’ = 418.

14. Qs.2. Get frequencies for the variable ‘negative stress index’ for cases where business is still open, managed by same BM and with complete information in 2000.

15. Answer to Qs.2 • Use filter to get ? cases? • Use filter to get 325 cases. • Use ? variable to get the frequencies? • Use variable nstress00 to get the frequencies. • N=?, missing =? Value Categories ? • N=325, missing =0. Value Categories 0,1,2,3.

16. Do you have any Questions? Need clarifications?

17. Next Webinar on May 19th • Next Webinar will be on 2007 filters • Homework Assignment will be e-mailed tomorrow.