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

st: RE: Export results after -tabdisp-

From   "Isabelle Deltour" <[email protected]>
To   <[email protected]>
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

Hope this helps

-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Herve STOLOWY
Sent: Friday, September 11, 2009 10:00 AM
To: [email protected]
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

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

HEC Paris
Departement Comptabilite Controle de gestion / Dept of Accounting and
Management Control
1, rue de la Liberation
78351 - Jouy-en-Josas
Tel: +33 1 39 67 94 42 - Fax: +33 1 39 67 70 86
mail: stolowy at hec dot fr

*   For searches and help try:

*   For searches and help try:

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