Hi everyone, A customer is using SAS 9.4 on-premise and connecting with CData ODBC Driver for Amazon Athena. The customer is from South Korea. Including that because the locales might affect the output just in case. I'm using SAS Viya free trial for testing purposes since SAS 9.4 doesnt have any free trial from what I've searched.  The customer has 2 problems: 1) DATE values in Athena such as : 2020-10-11 show in SAS as 11OCT2020 YYYY-MM-DD format shows in SAS as DDMMMYY. For this, I believe this DDMMMYY is the default date format in SAS. However, I want to be able to make the YYMMDD format by default whenever I get data from this driver, such as anytime I connect these DATE values show in YYMMDD format in SAS. How can I do this?   2) DECIMAL values in Athena, such as 42000000.00, 30099090.00, 395929 show as DOLLAR format in SAS. I read in SAS documentation that the default format for numeric values is BEST format. I havent made any changes in my SAS. Why is DOLLAR showing as default? Could it be a driver problem? And most importantly, how can I make the BEST format my permanent default format for decimal values?  I've seen some solutions researching but they mostly include formatting the columns in my query in the .sas program, so each time you run it it changes the format. However, I want to make it by default so I don't need to do all these extra steps in my code.   Could you please help me? If you need any additional details, feel free to ask me. Thank you in advance. ... View more