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.
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
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.
Ready to level-up your skills? Choose your own adventure.