Hi Guys,
I am reading data from DB2. there are records with Korean characters which appear as blanks when imported into SAS. See below:
Original Data from the source:
뵖 S 0 N6
뵲 S 0 NR
Data after the import into SAS;
S 0 N6
S 0 NR
If you have a look at the above dataset, the Korean character is not printable. Any suggestion to resolve this are highly welcome.
It is the same background as https://communities.sas.com/thread/60475
The best situation would all involved systems are supporting utf8. There must be one not doing that and being stuck on latin1/ansi.
To check:
- What is source system encoding? DB/2 running on mainframe/OS-type ?
- What is your current sas system encoding? OS-type / versions?
- How is the data transferred SAS/Access DB2? FTP? What are the encoding settings in these tools?
When you are going to use a SAS utf8 session remember the NLS manual to check all functions on compatibility.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.