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 a tab-delimitedformat?


From   Roger Newson <roger.newson@kcl.ac.uk>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: RE: Export of a -tab3way- table in a tab-delimitedformat?
Date   Thu, 31 Mar 2005 19:38:44 +0100

You should probably use -xcontract- to create resultssets for each nonempty subset of the 3 variables, concatenate these resultssets to form a single long resultsset using -dsconcat- (also downloadable from SSC), sort this long resultsset by "Formation administrative", "Formation scientifique" and "Formation de gestion", and then use the official Stata command -reshape wide- on the resultsset to create a dataset with 1 obs per value of "Formation administrative" (including a missing value for the totals) and data on the 9 totals for the 9 combinations of "Formation scientifique" and "Formation de gestion" (including the totals). This final wide resultsset can then be output using -outsheet- or -listtex- to produce the generic spreadsheet you want.

Although Stata does not have a comprehensive table-generating utility like PROC TABULATE in SAS, Stata can usually create any table as a Stata dataset (or resultsset) with 1 obs per table row. This can usually be done using -dsconcat- and/or -reshape-. We can then use -outsheet-, -listtex-, StatTransfer etc. to reformat this table for delivery to the end user.

I hope this helps.

Roger


At 17:44 31/03/2005, Herve wrote:

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.

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



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