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: [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/