BookmarkSubscribeRSS Feed

See All of Your Characters in SAS® Studio

Started ‎06-26-2020 by
Modified ‎06-26-2020 by
Views 1,841

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.

 

 

 

 

Video highlights

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

 

Read the Paper

 

Related resources

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)

Comments

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.

Version history
Last update:
‎06-26-2020 02:26 PM
Updated by:

SAS Innovate 2025: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!

Submit your idea!

Free course: Data Literacy Essentials

Data Literacy is for all, even absolute beginners. Jump on board with this free e-learning  and boost your career prospects.

Get Started

Article Tags