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/
