|
可以使用putexcel输出。
举例:
sysuse auto
tabulate foreign, matcell(freq) matrow(names)
putexcel A1=("Car type") B1=("Freq.") C1=("Percent") D1=("Cum.") using results, replace
local rows = rowsof(names)
local row = 2
local cum_percent = 0
forvalues i = 1/`rows' {
local val = names[`i',1]
local val_lab : label (foreign) `val'
local freq_val = freq[`i',1]
local percent_val = `freq_val'/`r(N)'*100
local percent_val : display %9.2f `percent_val'
local cum_percent : display %9.2f (`cum_percent' + `percent_val')
putexcel A`row'=("`val_lab'") B`row'=(`freq_val') C`row'=(`percent_val') ///
D`row'=(`cum_percent') using results, modify
local row = `row' + 1
}
putexcel A`row'=("Total") B`row'=(r(N)) C`row'=(100.00) using results, modify
|