I have a lot of tables in which I have fields with Dutch, French and occasionally German names (I work in Belgium, where a majority is Dutch mother tongue, most others French and some German.) Often not all the fields are filled. For instance, communities usually have a name in one language, sometimes in two. A German mother tongue user would prefer the German name of a community (if it is filled in), else any other name that is filled in. The natural solution would be to create a calculated field like this IF (substr(browser.locale, 1, 2) = 'nl' and not 'Dutch name'n Missing )
RETURN 'Dutch name'n
ELSE (
IF (substr(browser.locale, 1, 2) = 'fr' and not 'French name'n Missing )
RETURN 'French name'n
ELSE (
IF (substr(browser.locale, 1, 2) = 'de' and not 'German name'n Missing )
RETURN 'German name'n
ELSE (
IF ( not 'Dutch name'n Missing )
RETURN 'Dutch name'n
ELSE (
IF ( not 'French name'n Missing )
RETURN 'French name'n
ELSE 'German name'n )))) Is something like that possible? (An improvement would be to take into account the second browser locale too.) Actually, why does SAS not offer a function that selects the best locale for you and you can use like this? localizeData('nl', 'Dutch name'n, 'fr' 'French name'n, 'de' 'German name')
... View more