BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
keerthi78890976
Obsidian | Level 7

Hi All,

 

After changing encoding to utf 8 from latin1 in sas , we are facing issue with registering tables in SMC. There are spaces showing up in table names. Below is the error when trying to register tables with spaces in table names.

 

NOTE: The autoexec file, /sas/sasconfig/Lev1/SASApp1/WorkspaceServer/autoexec.sas, was executed at server initialization.
1 LIBNAME srcch1_1 ODBC READ_LOCK_TYPE=NOLOCK READBUFF=1000 DATAsrc=xxx SCHEMA=dbo USER=xxx
1 ! PASSWORD=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX ;
NOTE: Libref SRCCH1_1 was successfully assigned as follows:
Engine: ODBC
Physical Name: xxx
2
2 The SAS System Friday, June 28, 2019 06:48:00 AM

NOTE: 34 table(s) not displayed/returned because the name is too long.
3 proc metalib;
4 omr (LIBURI="A5MSZA1O.BA0000SW" / project_reposid = "A5MSZA1O" );
5 REPORT(type = summary out = "tab_info");
6 SELECT ("A 

 

End of log.

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
keerthi78890976
Obsidian | Level 7

This issue is fixed, added following option in sasenv_local file : export EASYSOFT_UNICODE=YES;

View solution in original post

1 REPLY 1
keerthi78890976
Obsidian | Level 7

This issue is fixed, added following option in sasenv_local file : export EASYSOFT_UNICODE=YES;

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

Get Started with SAS Information Catalog in SAS Viya

SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 1191 views
  • 2 likes
  • 1 in conversation