do nlsw_data_setup tabout south race union sex using table1.xls, /// replace c(freq col) f(0c 1) /// title(Table 1: A Simple Example) /// fn(Source: modified nlsw88.dta) open do nlsw_data_setup tabout south race union sex using table2.xls, /// replace c(col row) f(1) /// title(Table 2: Some refinements, /// including the sample size) /// fn(Source: modified nlsw88.dta) /// npos(both) nlab(Sample size) open do nlsw_data_setup tabout south race union sex using table3.xls, /// replace c(col row) f(1) npos(both) /// nlab(Sample size) /// layout(cb) h3(nil) /// title(Table 3: Further refinements, /// using column block layout) /// fn(Source: nlsw88.dta) open do cancer_data_setup tabout stime died using table4.xls, /// replace c(freq col cum) /// f(0 1) clab(No. Col_% Cum_%) /// title(Table 4: Example of a simple /// cross tabulation) fn(Source: cancer.dta) open do nlsw_data_setup tabout south race collgrad [iw=wt] /// using table5.xls, replace /// c(freq row col) f(0c 1 1) layout(rb) /// h3(nil) /// title(Table 5: Example of cross tabulation /// using panels) fn(Source: nlsw88.dta) open do nlsw_data_setup tabout south race collgrad [iw=wt] /// using table6.xls, replace /// c(freq row col) f(0c 1p 1p) layout(rb) /// clab(_ _ _) h3(nil) /// title(Table 6: Same example with /// refinements) fn(Source: nlsw88.dta) open tabout south collgrad race /// using table7.xls, replace /// c(col) f(1) npos(row) /// clab(Col_%) stats(chi2) /// title(Table 7: Example of sample /// counts and stats) fn(nlsw88.dta) open tabout south collgrad race using table8.xls, /// replace c(col) f(1) clab(Col_%) /// stats(chi2) stpos(col) stlab(Chi2) /// plab(Signif) stars /// npos(row) nlab(Sample size) /// title(Table 8: Same example with /// customisation) fn(nlsw88.dta) open do nlsw_data_setup tabout industry occupation [iw=wt] /// using table9.xls, replace /// oneway c(freq col cum) f(0c 1) /// clab(Count Col_% Cum_%) /// npos(col) nlab(Sample) /// title(Table 9: A oneway table) /// fn(Source: nlsw88.dta) open sysuse auto, clear tabout rep78 foreign using table10.xls, /// replace c(mean weight) f(0c) sum /// h1(Car type (mean weight in lbs.)) h3(nil) /// title(Table 10: Simple twoway summary /// table of means) fn(auto.dta) open sysuse voter, clear tabout inc candidat using table11.xls, /// replace c(median pfrac) f(1) clab(%) sum /// title(Table 11: Simple twoway summary /// table of medians) fn(voter.dta) open sysuse auto, clear tabout foreign rep78 using table12.xls, /// replace sum npos(tufte) /// c(mean mpg mean weight mean length /// median price median headroom) /// f(1c 1c 1c 2cm 1c) h2(Mean Median) h2c(3 2) /// clab(MPG Weight_(lbs) Length_(in) /// Price Headroom_(in)) /// title(Table 12: Oneway summary table /// illustrating multiple summary measures) /// fn(Source: auto.dta) open do cancer_data_setup tabout died drug using table13.xls, /// replace sum c(mean age iqr age median studytime /// min studytime max studytime) f(1) /// title(Table 13: Oneway summary table /// with default headings) fn(Source: cancer.dta) /// open do cancer_data_setup tabout died drug using table14.xls, /// replace sum c(mean age iqr age median studytime /// min studytime max studytime) f(1) /// h2c(2 3) ltrim(1) h2(Patient_age_(years) /// Length_of_study_(months)) /// clab(Mean IQR Median Minimum Maximum) /// title(Table 14: Same oneway summary /// table with customised headings) /// fn(\emph{Source}: cancer.dta. Note that IQR /// is interquartile range) open use "http://www.stata-press.com/data/r14/nhanes2b", clear svyset psuid [pweight=finalwgt], strata(stratid) svy: tabulate race diabetes, row ci format(%7.3f) svy: tabulate sex diabetes, row ci format(%7.3f) use "http://www.stata-press.com/data/r14/nhanes2b", clear svyset psuid [pweight=finalwgt], strata(stratid) la var race "Race" la var sex "Sex" la var diabetes "Diabetes" la def ny 0 "No" 1 "Yes", modify la val diabetes ny tabout race sex diabetes using table16.xls, /// replace c(row ci) svy stats(chi2) f(3) cisep(-) /// npos(col) nlab(Sample size) h2c(2 2 1) /// title(Table 16: Survey data example) /// fn(Source: nhanes2b) open use "http://www.stata-press.com/data/r14/nhanes2b", clear svyset psuid [pweight=finalwgt], strata(stratid) la var race "Race" la var sex "Sex" la var diabetes "Diabetes" la def ny 0 "No" 1 "Yes", modify la val diabetes ny tabout race sex diabetes using table17.tex, /// replace style(tex) font(italic) twidth(16) /// c(row lb ub) svy stats(chi2) f(3) dpc /// npos(col) nlab(Sample size) h2c(3 3 1) /// title(Table 17: Survey data example with lb /// and ub options) fn(Source: nhanes2b. /// Note: lb lower bound; ub upper bound.) use "http://www.stata-press.com/data/r14/nhanes2b", clear svyset psuid [pweight=finalwgt], strata(stratid) la var race "Race" la var sex "Sex" la var diabetes "Diabetes" la def ny 0 "No" 1 "Yes", modify la val diabetes ny tabout race sex diabetes using table18.xls, /// replace c(row se) svy stats(chi2) f(1 3) per /// npos(col) nlab(Sample size) h2c(2 2 1) /// title(Table 18: Survey data example with /// standard errors) fn(Source: nhanes2b.) open use "http://www.stata-press.com/data/r14/nhanes2b", clear svyset psuid [pweight=finalwgt], strata(stratid) la var race "Race" la var sex "Sex" la var diabetes "Diabetes" la def ny 0 "No" 1 "Yes", modify la val diabetes ny tabout race sex diabetes using table19.xls, /// replace c(row se) svy f(1 3) per seb /// npos(col) nlab(Sample size) h2c(2 2 1) /// stats(chi2) stpos(col) ppos(only) stars /// title(Table 19: Survey data with stars for /// significance) fn(Source: nhanes2b.) open do nlsw_data_setup svyset [pw=wt] tabout occupation south race collgrad /// using table20.xls, replace /// c(mean wage se) /// f(2 2) clab(Mean_wage SE) sum svy /// npos(lab) h2c(2 2 2) /// title(Table 20: Twoway summary table with /// survey data) fn(Source: nslw88.dta) open do nlsw_data_setup svyset [pw=wt] tabout occupation south collgrad /// using table21.xls, replace /// c(mean wage ci) /// f(2 2) clab(_ (90%_CI)) sum svy /// level(90) npos(lab) layout(row) /// h3(Average_wage) h3c(3) /// title(Table 21: Twoway summary table /// with row layout) fn(Source: nslw88.dta) open do nlsw_data_setup tabout south sex union race [iw=wt] /// using table22.xls, replace /// c(freq row) f(0c) /// title(Table 22: Unnecessary columns) /// fn(Source: nlsw88.dta) show(none) open do nlsw_data_setup tabout south sex union race [iw=wt] /// using table23.xls, replace /// c(freq row) f(0c) /// dropc(6 7 9) show(prepost) clab(No. Row_%) /// title(Table 23: Dropping columns) /// fn(Source: nlsw88.dta. Note that "Other" /// category has been omitted, so totals will /// not be accurate.) open do nlsw_data_setup tabout south sex race union [iw=wt] /// using table24.xls, replace /// c(freq col) f(0c) /// dropr(3:5) show(prepost) /// title(Table 24: Dropping rows) /// fn(Source: nlsw88.dta. Note that "Other" /// category has been omitted, so totals will /// not be accurate.) open do nlsw_data_setup tabout south pregnant union race sex [iw=wt] /// using table25.xls, replace /// c(freq col) f(0c) /// title(Table 25: Problem with gaps) /// fn(Source: nlsw88.dta) open do nlsw_data_setup tabout south pregnant union race sex [iw=wt] /// using table26.xls, replace /// c(freq col) f(0c) /// plugc(2:2 2:3) plugsym(NA) show(prepost) /// title(Table 26: Plugging columns) /// fn(Source: nlsw88.dta) open do nlsw_data_setup tabout pregnant south union race sex [iw=wt] /// using table27.xls, replace /// c(freq col) f(0c) /// plugc(1:2 1:3) show(prepost) /// title(Table 27: Plugging columns - a problem) /// fn(Source: nlsw88.dta) open do nlsw_data_setup tabout pregnant south union race sex [iw=wt] /// using table28.xls, replace /// c(freq col) f(0c) /// plugc(1:2 1:3) /// h2(Male Female Total) h2c(2 2 2) /// h3(No. % No. % No. %) h3c(1 1 1 1 1 1) /// title(Table 28: Plugging columns - /// fixing the problem) fn(Source: nlsw88.dta) open do nlsw_data_setup svyset [pw=wt] tabout south collgrad /// using table29.xls, replace /// c(mean wage ci) /// f(2 2) clab(_ _ _) sum svy /// level(90) npos(lab) layout(row) /// h3(Average_wage) h3c(3) /// title(Table 29: Twoway summary table /// showing use of h3c) fn(Source: nslw88.dta) /// open do nlsw_data_setup tabout south union race sex pregnant [iw=wt] /// using table30.xls, replace /// c(freq row) f(0c) /// title(Table 30: Plugging rows - the problem) /// fn(Source: nlsw88.dta) open do nlsw_data_setup tabout south union race sex pregnant [iw=wt] /// using table31.xls, replace /// c(freq row) f(0c) /// plugr(4:3) pluglab(Male*) plugsym(0) /// title(Table 31: Plugging rows - the solution) /// fn(Source: nlsw88.dta. Note: * No male /// pregnancies have been reported.) open do nlsw_data_setup tabout industry occupation [iw=wt] /// using table32.xls, tp(oneway_basic_a.txt) /// title(Table 32: A oneway table using a template) /// open