asdocx tabulate with svy

asdocx works the same way with svy:tabulate command as it does with any other Stata command. We need to add asdocx to the beginning of the command line. This post shows the results from the Stata results window and asdocx for comparison for several key options of the svy:tabulate command. Let’s start with the default case, where we shall tabulate two variables without any tabulation options.

Default case: no options

 * use some example data  
 webuse nhanes2b 
 
 * default case: no option 
 svy: tabulate race diabetes

* The same if option cell is used
svy: tabulate race diabetes, cell
-------------------------------------
1=white,  |
2=black,  |   diabetes, 1=yes, 0=no  
3=other   |       0        1    Total
----------+--------------------------
    White |    .851    .0281    .8791
    Black |   .0899    .0056    .0955
    Other |   .0248  5.2e-04    .0253
          | 
    Total |   .9658    .0342        1
-------------------------------------
  Key:  cell proportion

  Pearson:
    Uncorrected   chi2(2)         =   21.3483
    Design-based  F(1.52, 47.26)  =   15.0056     P = 0.0000

asdocx results

asdocx svy: tabulate race diabetes
Tabulation of race diabetes
1=white, 2=black, 3=other diabetes, 1=yes, 0=no
0 1 Total
White 85.104 2.809 87.913
Black 8.989 0.564 9.553
Other 2.483 0.052 2.535
Total 96.575 3.425 100
Pearson Chi2 15.49
Prob. 0.0001

Weighted counts

svy: tabulate race diabetes , count

  svy: tabulate race diabetes, count  format(%14.0g)
(running tabulate on estimation sample)

Number of strata   =        31                Number of obs     =       10,349
Number of PSUs     =        62                Population size   =  117,131,111
                                              Design df         =           31

-------------------------------------------
1=white,  |
2=black,  |      diabetes, 1=yes, 0=no     
3=other   |         0          1      Total
----------+--------------------------------
    White |  99682793    3290354  102973147
    Black |  10528681     660555   11189236
    Other |   2908356      60372    2968728
          | 
    Total | 113119830    4011281  117131111
-------------------------------------------
  Key:  weighted count

  Pearson:
    Uncorrected   chi2(2)         =   21.3483
    Design-based  F(1.52, 47.26)  =   15.0056     P = 0.0000

asdocx results

asdocx svy: tabulate race diabetes , count
Tabulation of race diabetes
1=white, 2=black, 3=other diabetes, 1=yes, 0=no
0 1 Total
White 99682793 3290354 1.030e+08
Black 10528681 660555 11189236
Other 2908356 60372 2968728
Total 1.131e+08 4011281 1.171e+08
Pearson Chi2 15.49
Prob. 0.0001

 

Weighted counts and row percentages

* When option row and count are used together

 svy: tabulate race diabetes,  count row format(%9.0g)
----------------------------------------
1=white,  |
2=black,  |    diabetes, 1=yes, 0=no    
3=other   |        0         1     Total
----------+-----------------------------
    White | 9.97e+07   3290354  1.03e+08
          | .9680465  .0319535         1
          | 
    Black | 1.05e+07    660555  1.12e+07
          | .9409651  .0590349         1
          | 
    Other |  2908356     60372   2968728
          |  .979664   .020336         1
          | 
    Total | 1.13e+08   4011281  1.17e+08
          | .9657539  .0342461         1
----------------------------------------
  Key:  weighted count
        row proportion

  Pearson:
    Uncorrected   chi2(2)         =   21.3483
    Design-based  F(1.52, 47.26)  =   15.0056     P = 0.0000

asdocx svy: tabulate race diabetes , replace count row
Tabulation of race diabetes
1=white, 2=black, 3=other diabetes, 1=yes, 0=no
0 1 Total
White 99682793 3290354 1.030e+08
96.805 3.195 100
Black 10528681 660555 11189236
94.097 5.903 100
Other 2908356 60372 2968728
97.966 2.034 100
Total 1.131e+08 4011281 1.171e+08
96.575 3.425 100
Pearson Chi2 15.49
Prob. 0.0001

 

Weighted counts and column percentages

 * Weighted counts and column percentages
 svy: tabulate race diabetes , count col
 

 Number of strata =  31   Number of obs     =       10,349
Number of PSUs    =  62   Population size   =  117,131,111
                          Design df         =           31

-------------------------------------------
1=white,  |
2=black,  |      diabetes, 1=yes, 0=no     
3=other   |         0          1      Total
----------+--------------------------------
    White |  99682793    3290354  1.030e+08
          | .88121413  .82027512  .87912721
          | 
    Black |  10528681     660555   11189236
          | .09307547  .16467433  .09552745
          | 
    Other |   2908356      60372    2968728
          |  .0257104  .01505055  .02534534
          | 
    Total | 1.131e+08    4011281  1.171e+08
          |         1          1          1
-------------------------------------------
  Key:  weighted count
        column proportion

  Pearson:
    Uncorrected   chi2(2)         = 21.34
    Design-based  F(1.52, 47.26)  = 15.005  P = 0.000



 * using asdocx
 asdocx svy: tabulate race diabetes , count col
Tabulation of race diabetes
1=white, 2=black, 3=other diabetes, 1=yes, 0=no
0 1 Total
White 99682793 3290354 1.030e+08
88.121 82.028 87.913
Black 10528681 660555 11189236
9.308 16.467 9.553
Other 2908356 60372 2968728
2.571 1.505 2.535
Total 1.131e+08 4011281 1.171e+08
100 100 100
Pearson Chi2 15.49
Prob. 0.0001

column and row percentages

 *column and row percentages
 svy: tabulate race diabetes , col row 
 

 -------------------------------
1=white,  |  diabetes, 1=yes,  
2=black,  |        0=no        
3=other   |     0      1  Total
----------+--------------------
    White |  .968   .032      1
          | .8812  .8203  .8791
          | 
    Black |  .941   .059      1
          | .0931  .1647  .0955
          | 
    Other | .9797  .0203      1
          | .0257  .0151  .0253
          | 
    Total | .9658  .0342      1
          |     1      1      1
-------------------------------
  Key:  row proportion
        column proportion


 * using asdocx
 asdocx svy: tabulate race diabetes , row col
Tabulation of race diabetes
1=white, 2=black, 3=other diabetes, 1=yes, 0=no
0 1 Total
White 96.805 3.195 100
88.121 82.028 87.913
Black 94.097 5.903 100
9.308 16.467 9.553
Other 97.966 2.034 100
2.571 1.505 2.535
Total 96.575 3.425 100
100 100 100
Pearson Chi2 15.49
Prob. 0.0001

Weighted counts, column and row percentages

 *Weighted counts, column and row percentages
 svy: tabulate race diabetes , col row count
 
-------------------------------------
1=white,  |
2=black,  |   diabetes, 1=yes, 0=no  
3=other   |       0        1    Total
----------+--------------------------
    White | 1.0e+08  3.3e+06  1.0e+08
          |    .968     .032        1
          |   .8812    .8203    .8791
          | 
    Black | 1.1e+07  6.6e+05  1.1e+07
          |    .941     .059        1
          |   .0931    .1647    .0955
          | 
    Other | 2.9e+06  6.0e+04  3.0e+06
          |   .9797    .0203        1
          |   .0257    .0151    .0253
          | 
    Total | 1.1e+08  4.0e+06  1.2e+08
          |   .9658    .0342        1
          |       1        1        1
-------------------------------------
  Key:  weighted count
        row proportion
        column proportion


 * using asdocx
 asdocx svy: tabulate race diabetes , row col count
Tabulation of race diabetes
1=white, 2=black, 3=other diabetes, 1=yes, 0=no
0 1 Total
White 99682793 3290354 1.030e+08
96.805 3.195 100
88.121 82.028 87.913
Black 10528681 660555 11189236
94.097 5.903 100
9.308 16.467 9.553
Other 2908356 60372 2968728
97.966 2.034 100
2.571 1.505 2.535
Total 1.131e+08 4011281 1.171e+08
96.575 3.425 100
100 100 100
Pearson Chi2 15.49
Prob. 0.0001