complete column names (tab)

[River Huang]

Dear All, I found this question here. The data /code is:

* Example generated by -dataex-. To install: ssc install dataex
clear
input str16 var1 str7 var2
"测试长字符1" "地区1"
"测试长字符2" "地区1"
"测试长字符1" "地区1"
"测试长字符1" "地区1"
"测试长字符2" "地区2"
"测试长字符1" "地区1"
"测试长字符2" "地区2"
"测试长字符3" "地区2"
end

tab var2 var1

The outcome is:

. tab var2 var1

           |               var1
      var2 |  测试长..   测试长..   测试长.. |     Total
-----------+---------------------------------+----------
     地区1 |         4          1          0 |         5 
     地区2 |         0          2          1 |         3 
-----------+---------------------------------+----------
     Total |         4          3          1 |         8

The question is: How can we make the column names [测试长.. 测试长.. 测试长..] complete? Thanks.

[Maarten Buis]

If you have Stata 17 then table (var2) (var1) would be a possible sollution

[River Huang]

Dear Maarten, Thanks for this suggestion. Indeed, I have Stata 17 version:

However, I wonder if there is another solution if one doesn't have Stata 17. Thanks.

[Andrew Musau]

ssc install estout, replace

* Example generated by -dataex-. For more info, type help dataex
clear
input str16 var1 str7 var2
"测试长字符1" "地区1"
"测试长字符2" "地区1"
"测试长字符1" "地区1"
"测试长字符1" "地区1"
"测试长字符2" "地区2"
"测试长字符1" "地区1"
"测试长字符2" "地区2"
"测试长字符3" "地区2"
end

qui estpost tab var2 var1
esttab, cell(b(fmt(0))) unstack nonum collab(none) noobs modelwidth(15) ///
varlabels(`e(labels)') eqlabels(`e(eqlabels)', lhs("`e(rowvar)'")) mtitle("`e(colvar)'")

Res.:

. esttab, cell(b(fmt(0))) unstack nonum collab(none) noobs modelwidth(15) ///
> varlabels(`e(labels)') eqlabels(`e(eqlabels)', lhs("`e(rowvar)'")) mtitle("`e(colvar)'")

----------------------------------------------------------------------------
                        var1                                                
var2             测试长字符1     测试长字符2     测试长字符3           Total
----------------------------------------------------------------------------
地区1                      4               1               0               5
地区2                      0               2               1               3
Total                      4               3               1               8
----------------------------------------------------------------------------

[Romalpa Akzo]

table var2 var1, col row mi

[River Huang]

Dear @Andrew Musau and @Romalpa Akzo, Many thanks for these helpful suggestions.