BookmarkSubscribeRSS Feed

See All of Your Characters in SAS® Studio

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

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-2024.png

 

Time is running out to save with the early bird rate. Register by Friday, March 1 for just $695 - $100 off the standard rate.

 

Check out the agenda and get ready for a jam-packed event featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events. 

 

Register now!

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