Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

RE: Rép. : RE: Rép. : st: RE: Rép. : st: Re: Exporting results after -table-


From   "Martin Weiss" <[email protected]>
To   <[email protected]>
Subject   RE: Rép. : RE: Rép. : st: RE: Rép. : st: Re: Exporting results after -table-
Date   Wed, 10 Dec 2008 15:11:01 +0100

Line for the server...

Here we go! See -h tabout- and format your results in -tabout- appropriately. They are not zero, they are just rounded to zero...

HTH
Martin


-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Herve STOLOWY
Sent: Wednesday, December 10, 2008 3:09 PM
To: [email protected]
Subject: Rép. : RE: Rép. : st: RE: Rép. : st: Re: Exporting results after -table-

Dear Martin:

I really don't understand what's going on with my "if".

Here are some elements.

count if round>7 & round<26 & win==1 & offer==1
 2309

 table risk info , c(mean return) row col, if round>7 & round<26 &
win==1 & offer==1

----------------------------------------
          |             info            
     risk |  Limited      Full     Total
----------+-----------------------------
      Low | .0055178  .0061667  .0058304
     High | .0186253  .0108191  .0151296
          | 
    Total | .0124689  .0084756  .0106149
----------------------------------------

tabout risk info if round>7 & round<26 & win==1 & offer==1 using
table.txt , c(mean return) sum replace style(tab)

Table output written to: table.txt

        info            
risk    Limited Full    Total
        Mean return     Mean return     Mean return
Low     0.0     0.0     0.0
High    0.0     0.0     0.0
Total   0.0     0.0     0.0

I also tried the command lines you suggested with auto and it worked
perfectly.

Best regards

Herve

***********************************************************
Professeur/Professor
President of the French Accounting Association (AFC)
HEC Paris
Departement Comptabilite Controle de gestion / Dept of Accounting and
Management Control
1, rue de la Liberation
78351 - Jouy-en-Josas
France
Tel: +33 1 39 67 94 42 - Fax: +33 1 39 67 70 86
mail: stolowy at hec dot fr
web: http://www.hec.fr/stolowy
>>> "Martin Weiss" <[email protected]> 10/12/08 9:39 >>>
Line for the server...


What do you get with the equivalent -table- command? What do you get
from
-count if round>7 & round<26 & win==1 & offer==1-? It must be the -if-
qualifier that kills you. Try the example below and see whether the
zeros
reappear.

***********
sysuse auto, clear
table r f if w>2000 & r>2, c(mean mpg) row col
tabout r f using table1.txt if w>2000 & r>2, c(mean mpg) sum replace
style(tab)
!start table1.txt
***********

HTH
Martin

-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Herve STOLOWY
Sent: Wednesday, December 10, 2008 6:33 AM
To: [email protected]
Subject: Rép. : st: RE: Rép. : st: Re: Exporting results after -table-

Dear Nick and Martin:

Sorry about that. The typo was only in  my mail and not in the real
command:

tabout risk info using table.txt if round>7 & round<26 & win==1 &
offer==1,
c(mean return) sum replace style(tab)

Having said that, I still have the problem: only 0s are returned in the
table. (With no if, I get figures - but they do not correspond to my
sample,
because there is no if...).

Best regards

Herve

***********************************************************
Professeur/Professor
President of the French Accounting Association (AFC)
HEC Paris
Departement Comptabilite Controle de gestion / Dept of Accounting and
Management Control
1, rue de la Liberation
78351 - Jouy-en-Josas
France
Tel: +33 1 39 67 94 42 - Fax: +33 1 39 67 70 86
mail: stolowy at hec dot fr
web: http://www.hec.fr/stolowy
>>> "Nick Cox" <[email protected]> 09/12/08 22:29 >>>
Correct. That's a typo. Delete the ">". 

Nick 
[email protected] 

Martin Weiss

"& > offer==1" looks dubious to me...


*
*   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/

*
*   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/



© Copyright 1996–2024 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index