Dear Sven:
Everything is perfect now. Here are my final command lines:
generate fyr2 = string(fyr,"%tdCCYY-NN-DD")
tabulate fyr2 country if (post_ifrs==0 | post_ifrs==1) & ib_scaled!=. & sample_sum==1 & year_ifrs==1
tabout fyr2 country if (post_ifrs==0 | post_ifrs==1) & ib_scaled!=. & sample_sum==1 & year_ifrs==1 using table1, replace cells(freq) show(all)
I am sincerely grateful.
Best regards
Herve
***********************************************************
Professeur/Professor
President of the French Accounting Association (AFC)
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
>>> Svend Juul <[email protected]> 23/04/08 13:36 >>>
Herve wrote:
...
I did the following:
generate fyr2 = string(fyr,"%td")
It works but I now have a sorting problem. With the old fyr
variable, dates are ordered chronologically. With the new
fyr2 variable, dates are ordered "alphabetically".
...
========================================================
Use a sortable date format (year, month, day):
generate fyr2 = string(fyr,"%tdCCYY-NN-DD")
Best wishes,
Svend
__________________________________________
Svend Juul
Institut for Folkesundhed, Afdeling for Epidemiologi
(Institute of Public Health, Department of Epidemiology)
Vennelyst Boulevard 6
DK-8000 Aarhus C, Denmark
Phone: +45 8942 6090
Home: +45 8693 7796
Email: [email protected]
__________________________________________
*
* 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/
*
* 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/
