带有esttab的频率表

Question

我有兴趣使用Stata输出表命令命令的转置：

sysuse auto, clear

eststo: estpost tab foreign
esttab, cells(b)

这样

--------------------------------------------------
                      
                  Domestic    Foreign     Total 
                        
--------------------------------------------------
Domestic               52.      22.           74
--------------------------------------------------

我可以做类似的事情的输出：

sysuse auto, clear
est clear
tab foreign, gen(newp_`i')
eststo  : estpost tabstat newp_1 newp_2 , stat(sum ) column(variables)
drop newp* 



esttab, cells("newp_1 newp_2") ///
    compress unstack /// 
    nonumbers nodepvars noobs ///
    mtitles("Domestic" "Foreign")

...

------------------------------
            Domestic          
              newp_1    newp_2
------------------------------
sum               52        22
------------------------------

但是当我尝试添加其他变量计数时，我会遇到问题（理想情况下，我想要EST2要垂直附加而不是水平）

sysuse auto, clear
est clear
tab foreign, gen(newp_`i')
eststo  : estpost tabstat newp_1 newp_2 , stat(sum ) column(variables)
drop newp* 

esttab, cells("newp_1 newp_2") ///
    compress unstack /// 
    nonumbers nodepvars noobs ///
    mtitles("Domestic" "Foreign")

g example = (mpg >=22)
tab example, gen(newp_`i')
eststo  : estpost tabstat newp_1 newp_2 , stat(sum ) column(variables)


esttab, cells("newp_1 newp_2") unstack ///
    compress  /// 
    nonumbers nodepvars noobs ///
    mtitles("Domestic" "Foreign")

...
--------------------------------------------------
            Domestic             Foreign          
              newp_1    newp_2    newp_1    newp_2
--------------------------------------------------
sum               52        22        43        31
--------------------------------------------------

我所需的输出是：

---------------------------------                                 
             newp_1    newp_2    
---------------------------------
sum (foreign)   52       22         
sum (price)     43       31
---------------------------------

Answer 1

以下似乎有效：

sysuse auto, clear
est clear


rename foreign binary1

g binary2 = (mpg >=22)
unab lst : binary*

foreach i in `lst'{ 
    tab `i', gen(test_`v')
    eststo: estpost tabstat test_*,  statistics(sum) columns(statistics)
    drop test_*
}




esttab , ///
    replace cell(sum ) ///
    compress /// 
    nonumbers rename("test_1" "Yes" "test_2" "No") /// 
    mtitles("Binary1" "Binary2")

            
matrix transp = r(coefs)'               
esttab matrix(transp), compress eqlabels(,merge)