I work in SAS Technical Support (TS). As discussed in the TS case:
Firstly I would suggest using the dedicated module SAS/Access to MS SQL Server. In order to use this module you'd need to change your SAS code to use:
srctype=’sqlserver’ in caslib and also sqlsvr engine in libname (instead of odbc)
and then:
- set IANAAppCodePage=106 to reflect utf-8 in Viya,
- column type names in SQL Server are expected to begin with n like nchar, nvarchar.
... View more