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