Dear Statalisters:
I run the following command with -tabulate-:
tabulate fyr country if (post_ifrs==0 | post_ifrs==1) & ib_scaled!=. & sample_sum==1 & year_ifrs==1
fyr is the date of the financial year end. Here is the beginning of the output:
| country
fyr | AUS FRA GBR | Total
-----------+---------------------------------+----------
31 Mar 05 | 0 1 0 | 1
30 Jun 05 | 1 2 0 | 3
30 Sep 05 | 0 1 0 | 1
30 Dec 05 | 0 0 2 | 2
As you can see, I have no problem with the dates.
I want to export this table with -tabout- (downloadable from ssc). Here is my command line:
tabout fyr country if (post_ifrs==0 | post_ifrs==1) & ib_scaled!=. & sample_sum==1 & year_ifrs==1 using table0, replace cells(freq) show(all)
Unfortunately, I don't get the dates in the format I want. Here is the beginning of the output:
country
fyr AUS FRA GBR Total
No. No. No. No.
16526 0.0 1.0 0.0 1.0
16617 1.0 2.0 0.0 3.0
16709 0.0 1.0 0.0 1.0
16800 0.0 0.0 2.0 2.0
16801 56.0 267.0 171.0 494.0
Do you know a way to get the "regular" date format with -tabout-?
If it is necessary, I may add that I get the following elements when I ask for describe:
fyr long %tdD_m_Y fyr
Best regards
Herve Stolowy
***********************************************************
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
*
* 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/
