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: [email protected]
__________________________________________
*
* 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/
