topic Re: encoding of SAS stored procedure in Administration and Deployment

encoding of SAS stored procedure

rudfaden — Tue, 19 Jul 2022 08:46:49 GMT

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

Re: encoding of SAS stored procedure

gwootton — Tue, 19 Jul 2022 16:10:33 GMT

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#p0x4ziblwbjcbgn1xx91pk0sjwzt

Re: encoding of SAS stored procedure

rudfaden — Wed, 20 Jul 2022 09:05:32 GMT

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

Re: encoding of SAS stored procedure

AhmedAl_Attar — Wed, 20 Jul 2022 10:54:20 GMT

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.

Re: encoding of SAS stored procedure

Sajid01 — Wed, 20 Jul 2022 10:58:46 GMT

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#:~:text=When%20a%20file%20that%20contains,the%20current%20SAS%20session%20encoding.

This should help you.

Re: encoding of SAS stored procedure

rudfaden — Thu, 21 Jul 2022 07:42:06 GMT

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