do nlsw_data_setup
tabout south race union sex using table1.xlsx, ///
replace c(freq col) f(0c 1) font(bold) style(xlsx) ///
title(Table 1: A Simple Example) ///
fn(Source: nlsw88.dta) open

tabout south race union sex using table2.xlsx, ///
replace c(col row) f(1) style(xlsx) ///
font(italic) ///
title(Table 2: Some refinements, ///
including the sample size) ///
fn(Source: nlsw88.dta) ///
npos(both) nlab(Sample size) open

tabout south race union sex using table3.xlsx, ///
replace style(xlsx) font(italic) ///
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.xlsx, ///
replace c(freq col cum) style(xlsx) ///
font(italic)  ///
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.xlsx, replace style(xlsx) ///
c(freq row col) f(0c 1 1) layout(rb) ///
h3(nil) font(bold) ///
title(Table 5: Example of cross tabulation ///
using panels) fn(Source: nlsw88.dta) open

tabout south race collgrad [iw=wt] ///
using table6.xlsx, replace style(xlsx) ///
c(freq row col) f(0c 1p 1p) layout(rb) ///
clab(_ _ _) h3(nil) font(bold) ///
title(Table 6: Same example with ///
refinements) fn(Source: nlsw88.dta) open

tabout south collgrad race ///
using table7.xlsx, replace style(xlsx) ///
c(col) f(1) npos(row) font(bold) ///
clab(Col_%) stats(chi2) ///
title(Table 7: Example of sample ///
counts and stats) fn(nlsw88.dta) open

tabout south collgrad race using table8.xlsx, ///
replace style(xlsx) font(bold) ///
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

tabout industry occupation [iw=wt] /// 
using table9.xlsx, replace style(xlsx) ///
font(bold) 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 table10b.xlsx, ///
replace style(xlsx) font(italic) ///
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.xlsx, ///
replace style(xlsx) font(italic) ///
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.xlsx, ///
replace style(xlsx) font(bold)  ///
sum npos(tufte) hright ///
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 ptotal(none)

do cancer_data_setup
tabout died drug  using table13.xlsx, ///
replace style(xlsx) font(italic) ///
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

tabout died drug  using table14.xlsx, ///
replace style(xlsx) font(italic) ///
sum c(mean age iqr age median studytime ///
min studytime max studytime) f(3) ///
h2c(2 3) 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(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)

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.xlsx, ///
replace style(xlsx) font(italic)  ///
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) cwidth(15) indent(1) open

tabout race sex diabetes using table17.xlsx, ///
replace style(xlsx) font(italic) ///
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.) open

tabout race sex diabetes using table18.xlsx, ///
replace style(xlsx) font(italic)  ///
c(row se) svy stats(chi2) f(1 3) mult(100) ///
npos(col) nlab(Sample size) h2c(2 2 1) ///
title(Table 18: Survey data example with ///
standard errors) fn(Source: nhanes2b.) open

tabout race sex diabetes using table19.xlsx, ///
replace style(xlsx) font(italic)  ///
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.xlsx, replace style(xlsx) ///
font(italic) 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

svyset [pw=wt]
tabout occupation south collgrad ///
using table21.xlsx, replace style(xlsx) ///
font(italic) c(mean wage ci) ///
f(2 2) clab(_ (90%_CI)) sum svy ///
level(90) npos(lab) layout(row) ///
h3(Average_wage) h3c(3) cwidth(15) indent(1) ///
title(Table 21: Twoway summary table ///
with row layout)  fn(Source: nslw88.dta) open

tabout south sex union race [iw=wt] ///
using table22.xlsx, replace style(xlsx) ///
font(bold) c(freq row) f(0c)  ///
title(Table 22: Unnecessary columns) ///
fn(Source: nlsw88.dta) show(none) open

tabout south sex union race [iw=wt] ///
using table23.xlsx, replace style(xlsx) ///
font(bold) 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

tabout south sex race union [iw=wt] ///
using table24.xlsx, replace style(xlsx) ///
font(bold) 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

tabout south pregnant union race sex [iw=wt] ///
using table25.xlsx, replace style(xlsx) ///
font(bold) c(freq col) f(0c) ///
title(Table 25: Problem with gaps) ///
fn(Source: nlsw88.dta). open

tabout south pregnant union race sex [iw=wt] ///
using table26.xlsx, replace style(xlsx) ///
font(bold) c(freq col) f(0c)  ///
plugc(2:2 2:3) plugsym(NA) show(prepost) ///
title(Table 26: Plugging columns) ///
fn(Source: nlsw88.dta) open

tabout pregnant south union race sex [iw=wt] ///
using table27.xlsx, replace style(xlsx) ///
font(bold) c(freq col) f(0c)  ///
plugc(1:2 1:3) show(prepost) ///
title(Table 27: Plugging columns - a problem) ///
fn(Source: nlsw88.dta) open

tabout pregnant south union race sex [iw=wt] ///
using table28.xlsx, replace style(xlsx)  ///
font(bold) 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

svyset [pw=wt]
tabout south collgrad ///
using table29.xlsx, replace style(xlsx) ///
font(italic) c(mean wage ci) ///
f(2 2) clab(_ _ _) sum svy ///
level(90) npos(lab) layout(row) ///
h3(Average_wage) h3c(3) cwidth(15) indent(1) ///
title(Table 29: Twoway summary table ///
showing use of h3c)  fn(Source: nslw88.dta) open

tabout south union race sex pregnant [iw=wt] ///
using table30.xlsx, replace style(xlsx) ///
font(bold) c(freq row) f(0c)  ///
title(Table 30: Plugging rows - the problem) ///
fn(Source: nlsw88.dta) open

tabout south union race sex pregnant [iw=wt] ///
using table31.xlsx, replace style(xlsx) ///
font(bold) 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

tabout industry occupation [iw=wt] ///
using table32.xlsx, tp(oneway_basic_d.txt) ///
title(Table 32: A oneway table using a template) open

tabout south race union sex using table40.xlsx, ///
replace c(freq col) f(0c 1) font(bold) style(xlsx) ///
title(Table 40: Multiple tables on one sheet - ///
first table) fn(Source: nlsw88.dta) /// 
location(4 2) lwidth(25) cwidth(15)

tabout south race collgrad [iw=wt] ///
using table40.xlsx, append style(xlsx) ///
c(freq row col) f(0c 1 1) layout(rb) h3(nil) ///
font(bold) title(Table 41: Multiple tables on ///
one sheet - second table) fn(Source: nlsw88.dta) ///
location(26 2) lwidth(25) cwidth(15)

tabout south race union sex using table42.xlsx, ///
replace c(freq col) f(0c 1) font(bold) style(xlsx) ///
title(Table 42: Multiple tables on multiple sheets - ///
first table on first sheet) fn(Source: nlsw88.dta) /// 
location(4 2) lwidth(25) cwidth(15) ///
sheet(My first sheet) 

tabout south race collgrad [iw=wt] ///
using table42.xlsx, append style(xlsx) ///
c(freq row col) f(0c 1 1) layout(rb) h3(nil) ///
font(bold) title(Table 43: Multiple tables on ///
multiple sheets - second table on first sheet) ///
fn(Source: nlsw88.dta) location(26 2) ///
lwidth(25) cwidth(15) sheet(My first sheet)

tabout south race union sex using table42.xlsx, ///
append c(freq col) f(0c 1) font(bold) style(xlsx) ///
title(Table 44: Multiple tables on multiple sheets - ///
third table on second sheet) fn(Source: nlsw88.dta) /// 
location(10 2) lwidth(25) cwidth(11) ///
sheet(My second sheet)

tabout south race collgrad [iw=wt] ///
using table42.xlsx, append style(xlsx) ///
c(freq row col) f(0c 1 1) layout(rb) h3(nil) ///
font(bold) title(Table 45: Multiple tables on ///
multiple sheets - fourth table on second sheet) ///
fn(Source: nlsw88.dta) location(10 13) ///
lwidth(25) cwidth(18) sheet(My second sheet) open