RE: st: table formatting in stata

[Haluk Vahaboglu <vahabo@hotmail.com>]

Sergiy thanks again, appreciated.

May I ask your attention to the help file examples:
(ttabtest price length weight headroom if mpg>22, by(foreign))

"ttabtest" seems wrong.

Thanks again 
All the best


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 23:10:38 -0400
> Subject: Re: st: table formatting in stata
> From: serjradyakin@gmail.com
> To: statalist@hsphsun2.harvard.edu
>
> Available from now on from the following (type in Stata's command
> line, NOT in browser):
>
> net from http://www.adeptanalytics.org/radyakin/stata/ttesttab
>
> If there is interest of other users this can be moved to SSC, and if
> the link above is no longer accessible, it is likely has moved there,
> so type: findit ttesttab
>
> Best, Sergiy Radyakin
>
>
> On Thu, Jun 6, 2013 at 6:55 PM, Haluk Vahaboglu <vahabo@hotmail.com> wrote:
>> 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/
>
> *
> * 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/