Statalist


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

=?UTF-8?Q?R=C3=A9p.=20:=20Re:=20st:=20date=20format=20in=20-tabo?==?UTF-8?Q?ut-?=


From   "Herve STOLOWY" <[email protected]>
To   <[email protected]>
Subject   =?UTF-8?Q?R=C3=A9p.=20:=20Re:=20st:=20date=20format=20in=20-tabo?==?UTF-8?Q?ut-?=
Date   Wed, 23 Apr 2008 08:54:49 +0200

Dear Sergiy:

Thank you for your reply. I now understand the origin of the problem.

I tried to convert the date into string with:
tostring fyr, generate(fyr2)

but it does not work. I get a variable with numbers:

    +-------------------+
       |       fyr    fyr2 |
       |-------------------|
    1. | 30 Jun 01   15156 |
    2. | 30 Jun 02   15521 |
    3. | 30 Jun 03   15886 |
    4. | 31 Dec 04   16436 |
    5. | 31 Dec 05   16801 |

Would you know how to make this conversion?

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
>>> "Sergiy Radyakin" <[email protected]> 23/04/08 3:09 >>>
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 <[email protected]> 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/


*
*   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–2024 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index