SAS® Studio is a programming environment that can run new and existing SAS® programs, read files from many data sources, and much more. When SAS programs, files, or data sets contain national characters, you might see truncated string, odd characters, or transcoding errors. In this 10-minute SAS Global Forum super demo, I show some common issues that occur when national characters are present and introduces you to tools and tips to help you achieve success.
00:18 - How to manage unexpected characters
01:48 - An example
03:32 - Two possible solutions
06:20 - Specify encoding with Open Dialog
07:27 - Two functions that can help: KPROPDATA and BASECHAR
A transcoding story (or, How Oliver S. Füßling lost his last name and comes to find it again) (blog post)
Demystifying and resolving common transcoding problems (blog post)
SAS National Language Support (NLS): Reference Guide (SAS documentation)
Thanks for this video, I'll read the aforementioned papers. Basechar() and Kpropdata() functions are especially useful with SAS SPRE sessions on Viya when dealing with extended (European here) Charsets.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
Data Literacy is for all, even absolute beginners. Jump on board with this free e-learning and boost your career prospects.