encoding of SAS stored procedure

[rudfaden]

I have a sas stored procedure where the encoding ends up as western-1252. I would like the encoding to be utf-8. As far as I can STP's as setup to use utf-8. 

Any idea of how to for

[gwootton]

Here is the documentation for creating a new application server context and setting it up to use unicode.

Create Unicode Application Server Context
https://go.documentation.sas.com/doc/en/bicdc/9.4/biasag/n10001intelplatform00srvradm.htm#p0x4ziblwb...

[rudfaden]

I already have a unicode server context. My problem is that the output from the sql server is not unicode. 

[AhmedAl_Attar]

First and foremost, you'll need to ensure you are running SAS with the correct encoding, then have a look at this SAS 9.4 link Multilingual Computing with SAS® 9.4, it has a section on SAS/ACCESS products and how to ensure proper encoding is preserved/used when extracting data from RDBMS

*If you are not using SAS 9.4, you'll need to search the equivalent document for your SAS release.

[Sajid01]

oks like your stored procedure is getting data from sql server and the encoding of the data is different.
In addition to what @AhmedAl_Attar  has said, have a look at the following from sas documentation

https://documentation.sas.com/doc/en/vdmmlcdc/8.1/nlsref/n0kzmrsdx5evkxn1ihs24h8ljg2b.htm 

https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/movefile/n06qan4j3ffr6fn11bs4q11r8r56.htm#:~:.... 

This should help you.

[rudfaden · Accepted solution]

The solution was to use nvarchar/nchar instead og varchar/char