Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: date format in -tabout-


From   "Herve STOLOWY" <stolowy@hec.fr>
To   <statalist@hsphsun2.harvard.edu>
Subject   st: date format in -tabout-
Date   Tue, 22 Apr 2008 22:40:26 +0200

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/



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