RE: st: table formatting in stata

[Haluk Vahaboglu <vahabo@hotmail.com>]

Sergiy thank you; this is excellent, indeed.
This must be organized as an *.ado command.



Prof. Dr. Haluk Vahaboğlu
Istanbul Medeniyet
Üniversitesi,
Göztepe Eğitim ve Araştırma Hastanesi
Enfeksiyon Hastalıkları
ve Klinik Mikrobiyoloji ABD
Dr. Erkin Caddesi 34730
Kadıköy / Istanbul TURKIYE




----------------------------------------
> Date: Thu, 6 Jun 2013 18:38:57 -0400
> Subject: Re: st: table formatting in stata
> From: serjradyakin@gmail.com
> To: statalist@hsphsun2.harvard.edu
>
> How about this? Sergiy
>
> sysuse auto, clear
>
> local vars "price length weight headroom"
> local gvar "foreign"
>
>
> local n=`:word count `vars''
> matrix R=J(`n',7,.)
> matrix list R
>
> forval i=1/`n' {
> local w `:word `i' of `vars''
> quietly ttest `w', by(`gvar')
> matrix R[`i',1]=r(N_1)
> matrix R[`i',2]=r(mu_1)
> matrix R[`i',3]=r(sd_1)
> matrix R[`i',4]=r(N_2)
> matrix R[`i',5]=r(mu_2)
> matrix R[`i',6]=r(sd_2)
> matrix R[`i',7]=r(p)
> }
>
> matrix coleq R = " " "Group 1" " " " " "Group 2" " " " "
> matrix colnames R = N mean SD N mean SD p
> matrix rownames R = `vars'
>
> matrix list R , format(%4.3f)
>
> On Thu, Jun 6, 2013 at 6:18 PM, Haluk Vahaboglu <vahabo@hotmail.com> wrote:
>> Sergiy,
>> Thank you for your contribution.
>> Unfortunately, tabstat do not generate a "p" value of T Test. I need n mean sd & "p" on a line.
>> Therefore, neither tabstat not tabstatmat resolve this problem.
>>
>>
>> Prof. Dr. Haluk Vahaboğlu
>> Istanbul Medeniyet
>> Üniversitesi,
>> Göztepe Eğitim ve Araştırma Hastanesi
>> Enfeksiyon Hastalıkları
>> ve Klinik Mikrobiyoloji ABD
>> Dr. Erkin Caddesi 34730
>> Kadıköy / Istanbul TURKIYE
>>
>>
>>
>>
>> ----------------------------------------
>>> Date: Thu, 6 Jun 2013 16:13:32 -0400
>>> Subject: Re: st: table formatting in stata
>>> From: serjradyakin@gmail.com
>>> To: statalist@hsphsun2.harvard.edu
>>>
>>> Yes, it is possible:
>>>
>>> sysuse auto,clear
>>> tabtstat price weight length, stats(mean sd)
>>>
>>> If you need it transposed, (and I assume you do) then add an option
>>> save to the above, then use Austin Nichols' -tabstatmat- to put
>>> results into matrix and transpose it. Type:
>>>
>>> findit tabstatmat
>>>
>>> and follow instructions.
>>>
>>> Best, Sergiy
>>>
>>>
>>> On Thu, Jun 6, 2013 at 5:11 AM, Haluk Vahaboglu <vahabo@hotmail.com> wrote:
>>>> TD P { margin-bottom: 0in; }P { margin-bottom: 0.08in; }
>>>>
>>>>
>>>> Hello Everybody,
>>>> In our research papers we
>>>> mostly present continuous data in a table with comparison to cases vs
>>>> controls as "n mean SD and p (from Ttest)". Here is a brief
>>>> example of such a table:
>>>>
>>>>
>>>>
>>>> ................Cases / Controls
>>>> ........N mean (SD) N mean (SD)...p
>>>> Var1
>>>> Var2
>>>>
>>>>
>>>>
>>>> With STATA I use these
>>>> commands
>>>>
>>>>
>>>>
>>>> 1. "estpost tabstat age
>>>> VAR1 VAR2, by(C/C) s(n mean sd) c(s)"
>>>> 2. "esttab ., main(mean)
>>>> aux(sd) unstack noobs nonote wide compress label"
>>>> 3. "estpost ttest age
>>>> VAR1 VAR2, by(C/C) une w"
>>>> 4. "esttab ., cell("p
>>>> (fmt(3))")"
>>>>
>>>>
>>>>
>>>> and get two separate
>>>> tables "n mean SD" in one and "p" in the other. I afterwards
>>>> combine these two in one table formatted as mentioned above.
>>>>
>>>>
>>>>
>>>> Is there any simple way to
>>>> get a table with n-mean-SD-p all in one line for multiple continuous
>>>> variables?
>>>> Thanks again
>>>> note: sorry for the subject line of my previous message
>>>>
>>>> *
>>>> * For searches and help try:
>>>> * http://www.stata.com/help.cgi?search
>>>> * http://www.stata.com/support/faqs/resources/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/faqs/resources/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/faqs/resources/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/faqs/resources/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/faqs/resources/statalist-faq/
*   http://www.ats.ucla.edu/stat/stata/