Table1 reporting unique missing value frequencies

[Jessica L]

#16353

Hello,

I’m using the template(table1) option for asdocx tab, and I’ve noticed that when I specify categorical variables with indicators (i.varname), the table generated includes statistics for all unique missing values (e.g. .d, .i, .s). I’m using a GSS dataset, which heavily utilizes unique mvs.

Also, is there a way to suppress p-values in tables?

Thank you.

[Attaullah Shah]

#16354

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

[Jessica L]

#16355

Hi Dr. Shah,

My mistake! I want to suppress the missing values.

I assumed this was an error because standard missing ” . ” are not reported in table1, only unique missing values. I’m not sure if asdocx tab supports the option listwise for deletion, but even when I add it the unique MVs are reported.

[Attaullah Shah]

#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%)

[Author]

Posts