asdocx: Export from Stata to Word, Excel, LaTeX & HTML › Forums › asdocx Forum › Adding column to table
Tagged: asdocx, customized table, flexmat, paired sample ttest

AuthorPosts

Hello
I have a dataset with variables that were asked twice, but with different references. I want to compilate a table of summary statistics comparing the following statistics between two versions of the variable: count mean sd var cv p50 skewness. Also I want to do an paired ttest between the two versions of the variable and report the twotailed pvalue in a column added to the table.
questions:
Is there some way I can write a code using docx comparing the two variables directly in the table by ex putting the statistics side by side?How can I add a column with the pvalue from the paired ttest between the two versions of the variable?
Hello Rune
Welcome to asdocx forum. I think you need some sort of a customized table, for which flexmat is a good choice. flexmat is part of the asdocx package and it is already installed if you have asdocx. There are several examples where I show how to make tables with flexmat, or modify tables that are already made by asdocx. References to these resources are given below. Please note the optiontranspose
, it changes the table layout from wide to long.1. Introduction to flexmat : [ view post here ]
2. Add a Stata matrix to existing asdocx table [view post here ]
3. Create tables by cells, rows, or columns [ YouTube Video ]
To give a quick start for your desired solution, let me present the following code:
* Load some example data sysuse bpwide * Create statistics with asdocx asdocx sum bp_before bp_after, stat(count mean sd var p50 skewness) replace transpose 0 1 2 3 + 1 Variables bp before bp after + 2 N 120 120 3 Mean 156.45 151.35833 4 Std. Dev. 11.38985 14.17762 5 variance 129.72857 201.00497 6 Median 154.5 149.5 7 skewness 0.54729 0.38843  * Conduct a two sample ttest ttest bp_before == bp_after * The pvalue from the ttest can now be appended to row 8 of the table created by asdoc flexmat addrow, data(pvalue, `r(p)') row(8) dec(4) Table: Summary Statistics 0 1 2 3 + 1 Variables bp before bp after + 2 N 120 120 3 Mean 156.45 151.35833 4 Std. Dev. 11.38985 14.17762 5 variance 129.72857 201.00497 6 Median 154.5 149.5 7 skewness 0.54729 0.38843 8 pvalue 0.0011  * Export the new table to MS Word asdocx export
Thank you Dr. Shah!

AuthorPosts
 You must be logged in to reply to this topic.