topic Re: SAS Enterprise Guide: Temporary changing encoding in a session in SAS Programming

SAS Enterprise Guide: Temporary changing encoding in a session

RLC07 — Thu, 25 Feb 2021 19:45:35 GMT

Hi SAS Gurus,

I have been a Base SAS user, on and off, for about 15 years and I am begrudgingly switching over to SAS Enterprise Guide because I can no longer get license renewed, at least currently, for PC SAS. In Base SAS, I primarily use SAS 9.4 (English) and have begun using SAS 9.4 (Unicode Support) to read in csv files that I must use 'encoding=wlatin2' in the data step (cannot read these files in with 'encoding='utf-8' in the data step).

I don't wish to permanent change the encoding in the session in Enterprise Guide, but would like to find a way to temporarily change the ending in a session to 'utf-8'. Is this possible? I followed 'B' and 'C' in this reference (https://communities.sas.com/t5/SAS-Communities-Library/Change-Encoding-using-SAS-Enterprise-Guide-Windowing-Environment/ta-p/597621) but my csv files were unable to be read in properly.

Many thanks in advance for your input.

Re: SAS Enterprise Guide: Temporary changing encoding in a session

SASKiwi — Thu, 25 Feb 2021 20:03:12 GMT

How about the ENCODING option on the FILENAME statement?

Re: SAS Enterprise Guide: Temporary changing encoding in a session

RLC07 — Thu, 25 Feb 2021 20:08:25 GMT

That was one of my first attempts and unfortunately, the characters cannot be read in correctly.

Re: SAS Enterprise Guide: Temporary changing encoding in a session

SASKiwi — Thu, 25 Feb 2021 20:16:13 GMT

What about in combination with OUTENCODING DATA step option? https://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.5&docsetId=nlsref&docsetTarget=n02q3gv9mfdwnmn1ca9kqa3gbayl.htm&locale=en

Re: SAS Enterprise Guide: Temporary changing encoding in a session

RLC07 — Thu, 25 Feb 2021 21:46:07 GMT

Unfortunately not.

Re: SAS Enterprise Guide: Temporary changing encoding in a session

ChrisNZ — Fri, 26 Feb 2021 00:30:23 GMT

1. You cannot temporarily change the encoding of a SAS session

2. The UTF8 session should be able to read the wlatin2 characters without problems (but not the other way around).

3. Show us the code you used, and show us characters that aren't read properly. Do not use Excel to display csv files.

What does it look like before SAS reads it, and in SAS after reading?
Do you have an hex editor to know exactly what the file contains?

Re: SAS Enterprise Guide: Temporary changing encoding in a session

RLC07 — Fri, 26 Feb 2021 23:32:17 GMT

Thank you. After chatting with the system analyst, I was able to access SAS EG in UTF-8 app server and subsequently was able to read in the csv files using the same program I had written previously in Base SAS. Thank you to everyone for all your input!