Hi Martin,
Yes, I adapted a program you created for me for continuous variables using:
mean1 (sd1) mean2 (sd2) p-value (from t-test).
Using the same format but for discrete variables instead with:
N1(colpercent1) N2 (colpercent2) p-value (from chi2) format.
I will look into estout/xml_tab. Thank you for your suggestions.
Eduardo
On Tue, Nov 24, 2009 at 9:53 AM, Martin Weiss <[email protected]> wrote:
>
> <>
>
>
>
> BTW, your strategy looks like one I have advocated in the past on the list,
> but certainly not to transfer " ... colpercent data from a 2x2 table into a
> word document". You may want to look for much more specialized tools, like
> Ben Jann`s -estout- suite of commands, or -xml_tab-...
>
>
>
> HTH
> Martin
>
>
> -----Ursprüngliche Nachricht-----
> Von: [email protected]
> [mailto:[email protected]] Im Auftrag von Eduardo Nunez
> Gesendet: Dienstag, 24. November 2009 15:35
> An: [email protected]
> Betreff: st: Programing error
>
> Dear Statalister,
>
> Please, I need help with the following:
> I am trying to export colpercent data from a 2x2 table into a word
> document using the following formatting:
>
> Variables SR (acxfa==0)
> AF (acxfa==1)
> N colpercent
> N colpercent P-value
>
> exitus_all N (%) 174 34.7
> 110 33.9 0.818
> Variable
> 2...........................................................................
> ................................................
> Others
> variables...................................................................
> ...............................................
>
> The 2x2 table for the first variables is below:
>
> . tab exitus_all acxfa, m col chi2
>
> +-------------------+
> | Key |
> |-------------------|
> | frequency |
> | column percentage |
> +-------------------+
>
> | acxfa
> exitus_all | 0 1 | Total
> -----------+----------------------+----------
> 0 | 327 214 | 541
> | 65.27 66.05 | 65.58
> -----------+----------------------+----------
> 1 | 174 110 | 284
> | 34.73 33.95 | 34.42
> -----------+----------------------+----------
> Total | 501 324 | 825
> | 100.00 100.00 | 100.00
>
> Pearson chi2(1) = 0.0530 Pr = 0.818
>
>
>
> This is the program I have tried:
> ----------------------------------------------------------------------------
> -------------------------------------------------------
> use "C:\Users\Eduardo\Desktop\ACXFA\Analysis\Cox_version_AHFi_June HR
> and AF.dta"
>
> tempname hdle
>
> capt erase info.dta
>
> postfile `hdle' str10 var sr_freq sr_colperc /*
> */ af_freq af_colperc overallfreq overallcolperc/*
> */ using info
>
>
> foreach var of varlist exitus_all rehosp rehosp_HF sudden_death
> hf_death othercvdeaths CV_death nonCV_death unknown_death {
> sum `var' if acxfa==0
> loc sr_freq=r(N)
> loc sr_colperc=r(mean)
> sum `var' if acxfa==1
> loc af_freq=r(N)
> loc af_colperc=r(mean)
> tab `var' acxfa, chi2
> local pval=r(p_lr)
> sum `var'
> post `hdle' ("`var'") (`sr_freq') (`sr_colperc') /*
> */ (`af_freq') (`af_colperc') (`pval') /*
> */ (r(N)) (r(mean))
> }
>
> postclose `hdle'
>
> use info, clear
> l, abbrev(12) noobs sep(0)
>
> ----------------------------------------------------------------------------
> ----------------------------------------------------------
>
> This is the error message I get:
> post: 7 expressions expected and more than 7 found
> r(198);
>
> end of do-file
>
>
> I would appreciate any suggestion.
> Thank you in advance,
>
> Eduardo
> *
> * For searches and help try:
> * http://www.stata.com/help.cgi?search
> * http://www.stata.com/support/statalist/faq
> * http://www.ats.ucla.edu/stat/stata/
>
>
> *
> * For searches and help try:
> * http://www.stata.com/help.cgi?search
> * http://www.stata.com/support/statalist/faq
> * http://www.ats.ucla.edu/stat/stata/
>
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
