Statalist


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

st: RE: Export results after -tabdisp-


From   "Isabelle Deltour" <deltour@cancer.dk>
To   <statalist@hsphsun2.harvard.edu>
Subject   st: RE: Export results after -tabdisp-
Date   Fri, 11 Sep 2009 11:27:18 +0200

Hi Herve:
My quick and dirty solution: 

contract  country_name language_firm
outsheet  country_name language_firm using test, noquote

it replaces your dataset in memory by a dataset containing the
frequencies of all the 
combinations of country*language then create a tab separated file called
test.

Hope this helps
Isabelle

-----Original Message-----
From: owner-statalist@hsphsun2.harvard.edu
[mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Herve STOLOWY
Sent: Friday, September 11, 2009 10:00 AM
To: statalist@hsphsun2.harvard.edu
Subject: st: Export results after -tabdisp-

Dear Statalisters:

I have a file with 205 companies and two variables: country of the
company and language spoken in the country. 

Here is an extract of my file.

company	country_name	language_firm
Ebh Bank AS (formerly Egnsbank Han Herred AS)	Denmark	Danish
Walls AS (formerly Theodor Ejendomsinvest AS)	Denmark	Danish
ChemoMetec AS	Denmark	Danish
Mols-Linien AS	Denmark	Danish
Codere SA	Spain	Spanish
Corporacion Dermoestetica SA	Spain	Spanish
Tiimari Oyj (formerly Leo Longlife Oyj)	Finland	Finnish
QPR Software Oyj	Finland	Finnish
Ruukki Group Oyj  (formerly A Company Finland Oyj)	Finland	Finnish

With -tabdisp-, I get a table showing each country and the language
spoken. 

tabdisp  country_name, cellvar( language_firm)

-----------------------------------
      Country name | Local language
-------------------+---------------
           Austria |         German
           Croatia |       Croatian
           Denmark |         Danish
           Finland |        Finnish
            France |         French
           Germany |         German
            Greece |          Greek
            Hungary |      Hungarian
             Italy |        Italian
         Lithuania |     Lithuanian
       Netherlands |          Dutch
            Norway |      Norwegian
            Poland |         Polish
          Portugal |     Portuguese
Russian Federation |        Russian
             Spain |        Spanish
            Sweden |        Swedish
             Turkey |        Turkish

Do you know a way to export the table obtained -tabdisp- to an excel
file -tab-delimited- file)? or to a matrix? Or, if this is not possible,
do you know another way to get this table which could be exported?

Best regards

Herve Stolowy




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


*
*   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–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index