Statalist


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

Re: st: date format in -tabout-


From   "Sergiy Radyakin" <serjradyakin@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: date format in -tabout-
Date   Tue, 22 Apr 2008 21:09:02 -0400

Dear Herve,

the last version of -tabout- by Ian Watson that I could find was dated
1apr2007, which is earlier than Stata 10 rolled out in the summer of
2007. Hence tabout is probably still not aware of date-formats added
in Stata 10. Since variable fyr has type long, it is represented in
tabout's output with proper integer formatting. If tabout was flexible
to support all Stata-defined formats, it would be possible to control
the output with the format option. Currently tabout does not have this
possibility. If you attempt to specify any d-formats, it will complain
"Error in format. Only the letters c, m and p are allowed."
Tabout supports strings, so you can convert the date-formatted values
to strings and use that string variable instead of fyr. Or contact the
author with a request.

Best regards, Sergiy Radyakin




On 4/22/08, Herve STOLOWY <stolowy@hec.fr> wrote:
> 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/
>
*
*   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