Dear Isabelle:
I thank you for your help. The solution of using -contract- is perfect for my need.
(If I may add, I replaced -outsheet- by -listtex- [downloadable from SSC]) because the latter allows to append tables, whch, to my knowledge, is not possible with the former).
Best regards
Herve
***********************************************************
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
>>> "Isabelle Deltour" <[email protected]> 11/09/09 11:27 >>>
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: [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
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/
*
* 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/
