Statalist


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

Re: st: Ignore accents while sorting international characters


From   Svend Juul <SJ@SOCI.AU.DK>
To   <statalist@hsphsun2.harvard.edu>
Subject   Re: st: Ignore accents while sorting international characters
Date   Wed, 18 Jun 2008 12:53:14 +0200

John LeBlanc wrote: 

How does one ignore accents while sorting international characters?

sort & gsort deliver this:

ecole
school
Úcole

What I'd like is this:
ecole
Úcole 
school

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

I believe that you must generate a second variable with no accents
to get it right:

    gen str10 key2=key
    replace key2 = subinstr(key2,"Ú","e",.)
    replace key2 = subinstr(key2,"˘","o",.)
    ...
    sort key2 key

I included key as a secondary sort key to make Ú come after e.

Hope this helps
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/



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