[Attaullah Shah]

in reply to: flexmat_to_excel error when using table1 template #16401

Please update to the beta version.

asdocx_update, beta

which asdocx

*!-------------------------------------------------------------------------------------+
*! Feb 24, 2022: Version 2.0.2 : Option sheet(name) add, it works with excel files.    |
*! Attaullah Shah; attaullah.shah@imsciences.edu.pk                                    |
*! Tenured Associate Professor: Institute of Management Sciences, Peshawar, Pakistan.  |
*!-------------------------------------------------------------------------------------+

[Attaullah Shah]

in reply to: Request for user command gologit2 support #16368

I have added gologit2 to asdocx. Since the output of the gologit2 comprises of three groups of estimates, asdocx add the group name as a prefix, that is fair, average, good. See this example

*Update asdocx
asdocx_update

* Use example data
webuse fullauto

*Add three nested models
asdocx gologit2 rep77 i.foreign length mpg, replace nest
asdocx gologit2 rep77 i.foreign length mpg trunk ,  nest
asdocx gologit2 rep77 i.foreign  mpg trunk ,  nest 

Table: Regression results

	(1)	(2)	(3)
	rep77	rep77	rep77
0bn.foreign
1.foreign	3.07	167.059	-1.596
	(7.081)	(38570.529)	(1.601)
length	0.447	17.56
	(0.316)	(3337.642)
mpg	0.505	24.289	-0.444
	(0.851)	(7408.473)	(0.45)
trunk		-23.61	-0.097
		(3518.731)	(0.281)
Intercept	-89.731	-3524.318	13.323
	(63.983)	(744600.61)	(12.56)
Fair:0bn.foreign
Fair:1.foreign	2.42*	1.861	1.213
	(1.346)	(1.341)	(0.904)
Fair:length	0.054	0.028
	(0.042)	(0.051)
Fair:mpg	0.26	0.279	0.224**
	(0.159)	(0.176)	(0.113)
Fair:trunk		0.108	0.182*
		(0.134)	(0.107)
Fair:Intercept	-14.632	-11.379	-5.968*
	(11.076)	(12.276)	(3.335)
Average:0bn.foreign
Average:1.foreign	3.569***	3.37***	1.524**
	(1.077)	(1.09)	(0.728)
Average:length	0.123***	0.122***
	(0.039)	(0.043)
Average:mpg	0.358***	0.372***	0.094
	(0.132)	(0.137)	(0.059)
Average:trunk		0.005	0.177*
		(0.118)	(0.092)
Average:Intercept	-32.637***	-32.861***	-5.5**
	(10.241)	(10.664)	(2.27)
Good:0bn.foreign
Good:1.foreign	19.883	24.247	20.503
	(1501.655)	(7320.255)	(2304.349)
Good:length	0.058	0.038
	(0.057)	(0.069)
Good:mpg	0.001	-0.032	-0.053
	(0.12)	(0.125)	(0.085)
Good:trunk		0.197	0.241
		(0.217)	(0.205)
Good:Intercept	-30.528	-32.583	-22.73
	(1501.716)	(7320.271)	(2304.351)
Observations	66	66	66
Pseudo R2	0.276	0.329	0.154

[Attaullah Shah]

in reply to: Get a table with the margins prediction | asdocx | Stata #16363

Hello Johanna
I have added margins to the asdocx. Now you can report a detailed table of margins [see this post ] or a nested table of margins [see this post ]

[Attaullah Shah]

in reply to: Table1 reporting unique missing value frequencies #16357

Please post your code to reproduce the error. For dropping the p-values column, you can use flexmat to modify the table created by asdocx. To know more about flexmat, you may like to read these entries.
Here is an example that deletes the p-value column.

sysuse nlsw88

*Since the p-values are in the 5th column, drop column 5.
flexmat dropcol, col(5)

*Export the modified table with asdocx
asdocx export

Table 1: Demographics

Variables	single (n=804)	married (n = 1442)	Total (2246)
race	1.40 (1.37 – 1.44)	1.21 (1.19 – 1.24)	1.28 (1.26 – 1.30)
current grade completed
0	1 (0.04%)	1 (0.04%)	2 (0.09%)
4	2 (0.09%)	1 (0.04%)	3 (0.13%)
5	0 (0.00%)	1 (0.04%)	1 (0.04%)
6	8 (0.36%)	6 (0.27%)	14 (0.62%)
7	9 (0.40%)	10 (0.45%)	19 (0.85%)
8	15 (0.67%)	18 (0.80%)	33 (1.47%)
9	23 (1.02%)	32 (1.43%)	55 (2.45%)
10	26 (1.16%)	58 (2.58%)	84 (3.74%)
11	45 (2.01%)	78 (3.48%)	123 (5.48%)
12	325 (14.48%)	618 (27.54%)	943 (42.02%)
13	60 (2.67%)	116 (5.17%)	176 (7.84%)
14	75 (3.34%)	112 (4.99%)	187 (8.33%)
15	33 (1.47%)	59 (2.63%)	92 (4.10%)
16	82 (3.65%)	170 (7.58%)	252 (11.23%)
17	34 (1.52%)	72 (3.21%)	106 (4.72%)
18	65 (2.90%)	89 (3.97%)	154 (6.86%)
lives in south
0	464 (20.66%)	840 (37.40%)	1304 (58.06%)
1	340 (15.14%)	602 (26.80%)	942 (41.94%)
college graduate
not college grad	616 (27.43%)	1098 (48.89%)	1714 (76.31%)
college grad	188 (8.37%)	344 (15.32%)	532 (23.69%)

[Attaullah Shah]

in reply to: Table1 reporting unique missing value frequencies #16354

The question on unique missing values seems incomplete to me. Do you want to report them or suppress them?

[Author]

Posts