Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

Re: st: RE: Export of a -tab3way- table in atab-delimitedformat?


From   "Herve STOLOWY" <stolowy@hec.fr>
To   <statalist@hsphsun2.harvard.edu>
Subject   Re: st: RE: Export of a -tab3way- table in atab-delimitedformat?
Date   Thu, 31 Mar 2005 18:44:05 +0200

Dear Roger:

I thank you for your help. I used xcontract with the following command:

xcontract form_gestion form_ad form_science if doublon==0 & formation_info==1,  saving(tab3way.dta, replace)

It works and I get the frequencies for each combination of the three variables.

However, I am looking for a method to transfer easily the following table obtained with tab3way:

Formation |          Formation scientifique and Formation de gestion         
administr | -------- 0 --------    -------- 1 --------    ------ TOTAL ------
ative     |     0      1  TOTAL        0      1  TOTAL        0      1  TOTAL
----------+------------------------------------------------------------------
        0 |    51    136    187      155     41    196      206    177    383
        1 |   111     54    165       35      3     38      146     57    203
    TOTAL |   162    190    352      190     44    234      352    234    586

xcontract provides the content of the above table but not as a three-way table.

Nick Cox wrote that there is no method (apart from the awful "cut and paste"). So, I fear it's hopeless.

Best regards

Hervé





***********************************************************
Professeur/Professor
Coordinateur du Département/Head of Department
HEC Paris
Département Comptabilité Contrôle 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
stolowy@hec.fr
http://campus.hec.fr/profs/stolowy/perso/home.htm
>>> roger.newson@kcl.ac.uk 03/31/05 5:41 PM >>>
>Herve STOLOWY wrote:
>
> > I use the -tab3way- command to cross-tabulate 3 variables. Do
> > you know if there is an easy way to get the output in a
> > tab-delimited format (something equivalent to -tabout- for a
> > two-way table or -estout- for a regression)?

What you are looking for might be -xcontract- (downloadable from SSC), 
which can produce output Stata datasets with 1 obs per combination of 
variable values (from 1, 2, 3, 4 or more variables) and data on frequencies 
and/or percentages. The output datasets (or resultssets) may be listed, 
written to a disk file, or written to memory, overwriting the pre-existing 
data. The resultsset can be converted to tab-delimited form by the official 
Stata -outsheet- command, or converted to tab-delimited or 
ampersand-delimited or HTML or TeX form by -listtex- (also downloadable 
from SSC).

I hope this helps.

Roger



--
Roger Newson
Lecturer in Medical Statistics
Department of Public Health Sciences
Division of Asthma, Allergy and Lung Biology
King's College London

5th Floor, Capital House
42 Weston Street
London SE1 3QD
United Kingdom

Tel: 020 7848 6648 International +44 20 7848 6648
Fax: 020 7848 6620 International +44 20 7848 6620
   or 020 7848 6605 International +44 20 7848 6605
Email: roger.newson@kcl.ac.uk
Website: http://phs.kcl.ac.uk/rogernewson/

Opinions expressed are those of the author, not the institution.

*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/


*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/



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