<>
You declared yourself satisfied, but still: In this particular case, you
could also simply -drop- the cases that are duplicates in terms of country
names and languages, and dump the resulting list into a new file with the
tools you have in mind...
******
clear*
input str60(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
end
compress
list, noobs
preserve
duplicates drop country_name language_firm, force
l country_name language_firm, noo
restore
******
HTH
Martin
-----Ursprüngliche Nachricht-----
Von: [email protected]
[mailto:[email protected]] Im Auftrag von Herve STOLOWY
Gesendet: Freitag, 11. September 2009 16:04
An: [email protected]
Betreff: Rép. : st: RE: Export results after -tabdisp-
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/
*
* 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/
