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

 From "Martin Weiss" To Subject RE: Rép. : RE: Rép. : st: RE: Rép. : st: Re: Exporting results after -table- Date Wed, 10 Dec 2008 15:16:30 +0100

```Line for the server...

See this example

***********
clear*
set seed 1010
set obs 100
g x=runiform()/1000
g dummy=runiform()>0.7
table dummy, c(mean x)
tabout dummy using table.txt, c(mean x) sum replace
tabout dummy using table.txt, c(mean x) sum f(6.5c) replace
***********

HTH
Martin

-----Original Message-----
From: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Herve STOLOWY
Sent: Wednesday, December 10, 2008 3:09 PM
To: statalist@hsphsun2.harvard.edu
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" <martin.weiss1@gmx.de> 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: owner-statalist@hsphsun2.harvard.edu
[mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Herve STOLOWY
Sent: Wednesday, December 10, 2008 6:33 AM
To: statalist@hsphsun2.harvard.edu
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" <n.j.cox@durham.ac.uk> 09/12/08 22:29 >>>
Correct. That's a typo. Delete the ">".

Nick
n.j.cox@durham.ac.uk

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