Problem with "asdoc" and the order of the categories

[jorge arenas molina]

Hi,
I have a problem with asdoc, I hope you can guide me.
The correct tab (with sum) is as follows:

but when I use asdoc (in different ways) the categories of the variable "region" get messed up. For example:


I hope you can help me identify the error.
Thanks

[William Lisowski]

Here is a simple reproducible example that confirms the problem, which as your example suggests, seems to be related to value labels that are not in alphabetical order as the values increase. Perhaps the author of asdoc will be able to comment on this.

* Example generated by -dataex-. For more info, type help dataex
clear
input float(cat val)
1 10
2 20
3 30
end
label values cat CAT
label def CAT 1 "A", modify
label def CAT 2 "C", modify
label def CAT 3 "B", modify

tabstat val, stat(mean) by(cat)

net install asdoc, from(http://fintechprofessor.com)
which asdoc

asdoc tabstat val, stat(mean) by(cat)

.
. tabstat val, stat(mean) by(cat)

Summary for variables: val
Group variable: cat

   cat |      Mean
-------+----------
     A |        10
     C |        20
     B |        30
-------+----------
 Total |        20
------------------

.
. net install asdoc, from(http://fintechprofessor.com)
checking asdoc consistency and verifying not already installed...
installing into /Users/lisowskiw/Library/Application Support/Stata/ado/plus/...
installation complete.

. which asdoc
/Users/lisowskiw/Library/Application Support/Stata/ado/plus/a/asdoc.ado
*! Attaullah Shah; [email protected]
*! Tenured Associate Professor at the Institute of Management Sciences, Peshawar, Pakistan.
*!-------------------------------------------------------------------------------
*! Version 2.3.9.5 : Changes made on April 10 , 2021   : Bug fixed in sum command when a variable had all empty values
...

.
. asdoc tabstat val, stat(mean) by(cat)
cat

             |       val
-------------+-----------
           A |        10
           B |        20
           C |        30
(file Myfile.doc not found)
Click to Open File:  Myfile.doc

.

[William Lisowski]

Attaullah Shah - Apologies for having not included this link in the previous post about asdoc, but I have been having problems adding links to my posts.

[Attaullah Shah]

William Lisowski Thanks for tagging me in the post. I have fixed the issue. The new version of asdoc can be installed from my site. Copy and paste the following line in Stata and press enter.

net install asdoc, from(http://fintechprofessor.com) replace

Please note that the above line has to be copied in full. After installation of the new version, then restart Stata.
I shall send an updated version to SSC.

asdoc tabstat val  , stat(mean ) by(cat) replace

asdocx is now available
A more powerful and flexible version of asdoc is now available. I call it asdocx. You may like to check the details here

https://fintechprofessor.com/asdocx


Please do remember to cite asdoc. To cite:

In-text citation
Tables were created using asdoc, a Stata program written by Shah (2018).

Bibliography
Shah, A. (2018). ASDOC: Stata module to create high-quality tables in MS Word from Stata output. Statistical Software Components S458466, Boston College Department of Economics.