asdocx with missings

missings is a community-contributed package written by Nicholas J. Cox. missings is a set of utility commands for managing and reporting variables that may have missing values. By default, “missing” means numeric missing (that is, the system missing value . or one of the extended missing values .a to .z) for numeric variables and empty or “” for string variables.

Users of asdocx have requested the addition of support for missings. Beginning with version 2.2.0, asdocx will now support it, allowing users to export its output table to Word, Excel, LaTeX, or HTML.

A slightly modified version of the program is available on the asdocx website, which is automatically downloaded when a user first uses it with asdocx. The modification is done to extract only the output matrix from the program and send it to asdocx, no other changes are made1. asdocx captures output from three sub-commands: report, table, and list. However, it does not generate any output from other sub-commands of missings. To use it with asdocx, simply add “asdocx” as a prefix. Here are some examples of how to use it with asdocx.

Missings report

  * Load example dataset
 weuse nlswork, clear
 
 * asdocx with missings
asdocx missings report, replace
Checking missings in all variables: 15082 observations with missing values
Variables missing
age 24
msp 16
nev_mar 16
grade 2
not_smsa 8
c_city 8
south 8
ind_code 341
occ_code 121
union 9296
wks_ue 5704
tenure 433
hours 67
wks_work 703

 

Missings table

  * Table of missing values
 asdocx missings table, replace
Checking missings in all variables: 15082 observations with missing values
# of missing values Freq. Percent Cumulative Freq.
0 13452 47.14 47.14
1 13790 48.33 95.47
2 964 3.38 98.85
3 291 1.02 99.87
4 32 0.11 99.98
5 2 0.01 99.99
6 3 0.01 100.00
Total 28534 100.00
Notes:

 

missings list

  * missings list lists observations with missing values in varlist.
 asdocx missings list, minimum(5) ///
 replace title(Table: List missing with at least 5 missing observations)
Table: List missing with at least 5 missing observations
age msp nev_mar not_smsa c_city south ind_code occ_code union wks_ue tenure hours wks_work
26 . . 0 1 0 11 8 . . 0.083 40 .
31 . . 0 1 1 7 8 . . 0.333 . .
26 1 0 . . . 7 3 . . 0.083 40 .
32 1 0 1 0 0 . . . . .75 . .
39 0 0 0 1 0 . 3 . . 1.5 . .
Notes:

See also: 
tabmany – Table of multiple coded answers

 

Order asdocx

Yearly license of asdocx is available at $9.99. Its life-time license is available at $49.99. With the asdocx membership, you get :

  • Life-time license to use
  • All future updates
  • All premium templates / plugins.

 

Order asdocx

 

Reference

Cox, N. J. (2015). Speaking Stata: A set of utilities for managing missing values. The Stata Journal, 15(4), 1174-1185.

Acknowledgment
1. We thank Dr Cox for permission to re-use his code and take full responsibility for the effects of any changes made in incorporating that code within asdocx.