asdocx: Export from Stata to Word, Excel, LaTeX & HTML Forums asdocx Forum Two-way Tab Missing Frequencies with matcell() Option Invoked Reply To: Two-way Tab Missing Frequencies with matcell() Option Invoked

Kevin Blaine
Participant
Post count: 45

Just to keep things as simple as possible, the same thing happens on the BPWide example dataset (no frequencies):



clear all

sysuse bpwide
(Fictional blood-pressure data)

cd "/Users/Default/Downloads"
/Users/Default/Downloads

asdocx tab sex agegrp, row save(test) replace

+----------------+
| Key            |
|----------------|
|   frequency    |
| row percentage |
+----------------+

           |            Age group
       Sex |     30-45      46-59        60+ |     Total
-----------+---------------------------------+----------
      Male |        20         20         20 |        60 
           |     33.33      33.33      33.33 |    100.00 
-----------+---------------------------------+----------
    Female |        20         20         20 |        60 
           |     33.33      33.33      33.33 |    100.00 
-----------+---------------------------------+----------
     Total |        40         40         40 |       120 
           |     33.33      33.33      33.33 |    100.00 
      - mata: write_full_matrix("`matname'", "`file'", `loc')
      = mata: write_full_matrix("/Users/Default/Downloads/_asdoc/current_file.asdoc", "/Users/Default/Downloads/_asdoc/test.flexmat", 1)
      - set trace off


   
                              Tabulation of sex agegrp
  0 |1                             2          3          4          5 
----+------------------------------------------------------------------------------
  1 | Sex                  Age group                                  
  2 |                          30-45      46-59        60+      Total 
----+------------------------------------------------------------------------------
  3 |Male                     33.333     33.333     33.333        100 
  4 |                                                                 
  5 |Female                   33.333     33.333     33.333        100 
  6 |                                                                 
  7 |Total                    33.333     33.333     33.333        100 
  8 |                                                                 
-----------------------------------------------------------------------------------
Notes:

Click to Open File:  /Users/Default/Downloads/test.docx

Can you replicate the issue?