Architecting, installing and maintaining your SAS environment

Change encoding to UTF-8 in SAS 9.3

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 5
Accepted Solution

Change encoding to UTF-8 in SAS 9.3

[ Edited ]

Hi All,

 

I intend to change the encoding from Wlatin1 to UTF-8. After a lot investifation , i came across a document that mentioned how same can be achieved:

 

https://support.sas.com/resources/papers/AddingAdditionalSASWorkspaceServerstoSupportMultipleEncodin...

 

As i have a unix environment, i added the "export SAS_COMMAND= $SASROOT/bin/sas_u8" line in the file WorkspaceServer_usermods.sh and restart the spawner. Unfortunately, since then I am unable to connect to the workspace server. Can someone please suggest what might have gone wrong and how i can switch to UTF-8.


Accepted Solutions
Solution
‎01-04-2018 11:27 AM
Frequent Contributor
Posts: 83

Re: Change encoding to UTF-8 in SAS 9.3

[ Edited ]
Posted in reply to jatin_singla

Hi @jatin_singla

Just check there is no space in the declaration:

(As mentioned above by you)

 

export SAS_COMMAND= $SASROOT/bin/sas_u8


(No space)

 

export SAS_COMMAND=$SASROOT/bin/sas_u8


If it fails again then I would suggest to see if logging can be enabled for WS Server to get more details.

Thanks,
AV

 

Other tips:

you can follow the steps here to create symlink to UTF-8 SAS.

http://support.sas.com/kb/51/586.html

 

And from @PaulHomes:

 I would suggest you log on to the server and attempt to run the sas_u8 command line, with all of the parameters as shown in the SAS Object Spawner log, as a user that it fails for, to see if you get any additional details are provided to explain the failure (make sure you omit any -noterminal parameter for an interactive test).

 

If that doesn't highlight the issue then I'd suggest the next course of action would be to contact SAS Technical Support.

View solution in original post


All Replies
PROC Star
Posts: 464

Re: Change encoding to UTF-8 in SAS 9.3

Posted in reply to jatin_singla

What errors are you seeing in your SAS Object Spawner log file (e.g. /opt/sas93/config/Lev1/ObjectSpawner/Logs/ObjectSpawner_2017-07-11_hostname_NNNN.log)?

 

Does the sas_u8 file exist in your $SASROOT/bin directory? e.g. /opt/sas93/sashome/SASFoundation/9.3/bin/sas_u8

Occasional Contributor
Posts: 5

Re: Change encoding to UTF-8 in SAS 9.3

Posted in reply to PaulHomes

The error is "Launch of server process failed with unknown status code (1)"

 

sas_u8 file does exist at the specified location.

PROC Star
Posts: 464

Re: Change encoding to UTF-8 in SAS 9.3

Posted in reply to jatin_singla

It looks like you are missing the unicode SAS launch script (and possibly wider unicode support) from your SAS Foundation installation.  Are you missing the unicode directory too? e.g. /opt/sas93/sashome/SASFoundation/9.3/nls/u8/

Occasional Contributor
Posts: 5

Re: Change encoding to UTF-8 in SAS 9.3

Posted in reply to PaulHomes

THanks for your response Paul.

 

The unicode directory is available at the location. Could you please suggest where I can find the unicode SAS launch script.

PROC Star
Posts: 464

Re: Change encoding to UTF-8 in SAS 9.3

Posted in reply to jatin_singla

It should have been created when SAS was installed. Has somebody deleted it? This is the diff between my SAS 9.3 sas_en and my sas_u8:

 

100c100
< SASCFGPATH="!SASROOT/sasv9.cfg, !SASROOT/nls/en/sasv9.cfg, !SASROOT/sasv9_local.cfg, $SASCFGPATH"
---
> SASCFGPATH="!SASROOT/sasv9.cfg, !SASROOT/nls/u8/sasv9.cfg, !SASROOT/sasv9_local.cfg, $SASCFGPATH"
102c102
< SASCFGPATH="!SASROOT/sasv9.cfg, !SASROOT/nls/en/sasv9.cfg, !SASROOT/sasv9_local.cfg"
---
> SASCFGPATH="!SASROOT/sasv9.cfg, !SASROOT/nls/u8/sasv9.cfg, !SASROOT/sasv9_local.cfg"

 

You should be able to use that the recreate a sas_u8 script from the sas_en script (if you don't have one available from a backup). Of course there may also be other things missing in which case I would contact your SAS installer and/or SAS tech support and look into re-installing any missing components.

Occasional Contributor
Posts: 5

Re: Change encoding to UTF-8 in SAS 9.3

[ Edited ]
Posted in reply to PaulHomes

Hi Paul,

The sas_en and sas_u8 scripts are available in SASROOT/bin. I happen to check the 100 and 102 of both the scripts and it matches with your sas_en and sas_u8 files.

PROC Star
Posts: 464

Re: Change encoding to UTF-8 in SAS 9.3

Posted in reply to jatin_singla

In that case I would suggest you log on to the server and attempt to run the sas_u8 command line, with all of the parameters as shown in the SAS Object Spawner log, as a user that it fails for, to see if you get any additional details are provided to explain the failure (make sure you omit any -noterminal parameter for an interactive test).

 

If that doesn't highlight the issue then I'd suggest the next course of action would be to contact SAS Technical Support.

Frequent Contributor
Posts: 83

Re: Change encoding to UTF-8 in SAS 9.3

Posted in reply to jatin_singla
Hi @jatin_singla

you can follow the steps here to create symlink to UTF-8 SAS.

http://support.sas.com/kb/51/586.html

Thanks,
AV
Occasional Contributor
Posts: 5

Re: Change encoding to UTF-8 in SAS 9.3

Hi Anand, thank you for your response.
I believe that the method specified in the link will change the encoding for all the workspace servers. I intend to change the encoding of one particular workspace server.
Solution
‎01-04-2018 11:27 AM
Frequent Contributor
Posts: 83

Re: Change encoding to UTF-8 in SAS 9.3

[ Edited ]
Posted in reply to jatin_singla

Hi @jatin_singla

Just check there is no space in the declaration:

(As mentioned above by you)

 

export SAS_COMMAND= $SASROOT/bin/sas_u8


(No space)

 

export SAS_COMMAND=$SASROOT/bin/sas_u8


If it fails again then I would suggest to see if logging can be enabled for WS Server to get more details.

Thanks,
AV

 

Other tips:

you can follow the steps here to create symlink to UTF-8 SAS.

http://support.sas.com/kb/51/586.html

 

And from @PaulHomes:

 I would suggest you log on to the server and attempt to run the sas_u8 command line, with all of the parameters as shown in the SAS Object Spawner log, as a user that it fails for, to see if you get any additional details are provided to explain the failure (make sure you omit any -noterminal parameter for an interactive test).

 

If that doesn't highlight the issue then I'd suggest the next course of action would be to contact SAS Technical Support.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 10 replies
  • 1215 views
  • 0 likes
  • 3 in conversation