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" <stolowy@hec.fr>
To   <statalist@hsphsun2.harvard.edu>
Subject   =?UTF-8?Q?R=C3=A9p.=20:=20Re:=20st:=20date=20format=20in=20-tabo?==?UTF-8?Q?ut-?=
Date   Wed, 23 Apr 2008 14:44:10 +0200

Dear Sven:

Everything is perfect now. Here are my final command lines:

generate fyr2 = string(fyr,"%tdCCYY-NN-DD")
tabulate  fyr2 country if (post_ifrs==0 | post_ifrs==1) & ib_scaled!=. & sample_sum==1 & year_ifrs==1
tabout fyr2 country  if (post_ifrs==0 | post_ifrs==1) & ib_scaled!=. & sample_sum==1 & year_ifrs==1 using table1, replace cells(freq)  show(all)

I am sincerely grateful.

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
>>> Svend Juul <SJ@SOCI.AU.DK> 23/04/08 13:36 >>>

Herve wrote:

...
I did the following:

generate fyr2 = string(fyr,"%td")

It works but I now have a sorting problem. With the old fyr 
variable, dates are ordered chronologically. With the new 
fyr2 variable, dates are ordered "alphabetically". 
...

========================================================

Use a sortable date format (year, month, day):

    generate fyr2 = string(fyr,"%tdCCYY-NN-DD")

Best wishes,
Svend

__________________________________________

Svend Juul
Institut for Folkesundhed, Afdeling for Epidemiologi
(Institute of Public Health, Department of Epidemiology)
Vennelyst Boulevard 6
DK-8000  Aarhus C, Denmark
Phone:  +45 8942 6090
Home:   +45 8693 7796
Email:  sj@soci.au.dk
__________________________________________ 

*
*   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