Is it possible to do a case-insensitive DISTINCT with SAS (PROC SQL)?

Question

Is there a way to get the case-insensitive distinct rows from this SAS SQL query? ... SELECT DISTINCT country FROM companies; The ideal solution would consist of a single query. Results now look like: Australia australia AUSTRALIA Hong Kong HONG KONG ... where any of the 2 distinct rows is really required One could upper-case the data, but this unnecessarily changes values in a manner that doesn't suit the purpose of this query.

Answer 1

SELECT DISTINCT UPCASE(country) FROM companies;

That will give you one line for each country, without changing the underlying data.