BookmarkSubscribeRSS Feed
AnandsinhSindha
Obsidian | Level 7

Hello Everyone,

 

I am using sas viya 3.05.

 

We create a ETL and make one target table and load that table in oracle database.

 

My target table have one variable "Father_Name" and some value of this variable is in local language.

So we can see these values in my sas enterprise guide.

                                         AnandsinhSindha_1-1601282205765.png

 

 

but when we load this table Oracle_DB To CAS server on sas viya,and check my data into cas  the Father_Name variable values look like this "???????? ?????".It looks not good is in our VA reports.

                               AnandsinhSindha_0-1601281696785.png

 

 data properties in sas viya data encoding type= UTF-8 ,observations=12 million ,Columns=22

 

So how can we resolve this issue in sas-viya. Can anyone suggest us.

Thanks in advance.

1 REPLY 1
RonAgresta
SAS Employee

Can you be more specific about what application or component of SAS Viya you are using when you say you created an ETL? Or have you created a SAS Enterprise Guide job to load data into a CAS table on SAS Viya?

 

Ron

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 814 views
  • 0 likes
  • 2 in conversation