We use cookies, including third-party cookies from Google to serve personalized ads through AdSense, to operate this site and understand how it is used. By continuing to browse, you accept this use. See our Privacy Policy and Terms of Use for details, including how to opt out of personalized advertising.
Accept
SmartData CollectiveSmartData Collective
  • Analytics
    AnalyticsShow More
    Flat editorial illustration: The article is about joining public web signals with internal business metrics so BI teams can inter
    Alternative Data in BI: Bringing Public Web Data Into Your Dashboards
    23 Min Read
    Flat editorial illustration: The article is about automating the collection, preparation, and delivery of marketing data across p
    From Data to Dashboards: 5 Marketing Reporting Automation Software Picks
    12 Min Read
    Flat editorial illustration: The article contrasts passive follower totals with a behavioral path from attention and trust to cli
    Creator Analytics Beyond Follower Count: Seven Metrics That Measure Audience Behavior
    11 Min Read
    Flat editorial illustration: The article connects AI and marketing analytics with managerial judgment grounded in consumer behavi
    How an Online MBA in Marketing Connects AI and Data Analytics
    11 Min Read
    What Kind of Problem-Solving Distinguishes Data Analysts From Software Engineers -- AI-generated illustration
    What Kind of Problem-Solving Distinguishes Data Analysts From Software Engineers
    7 Min Read
  • Big Data
  • BI
  • Exclusive
  • IT
  • Marketing
  • Software
Search
© 2008-25 SmartData Collective. All Rights Reserved.
Reading: SAS Visual Analytics: Tips for Unriddling Encoding in SAS Visual Analytics 6.3
Share
Notification
Font ResizerAa
SmartData CollectiveSmartData Collective
Font ResizerAa
Search
  • About
  • Help
  • Privacy
Follow US
© 2008-23 SmartData Collective. All Rights Reserved.
SmartData Collective > Uncategorized > SAS Visual Analytics: Tips for Unriddling Encoding in SAS Visual Analytics 6.3
Uncategorized

SAS Visual Analytics: Tips for Unriddling Encoding in SAS Visual Analytics 6.3

Tricia Aanderud
Tricia Aanderud
3 Min Read
SAS Visual Analytics: Tips for Unriddling Encoding in SAS Visual Analytics 6.3
Illustrative image generated with OpenAI gpt-image-1.
SHARE

Author: Michelle Homes

Contents
  • So we had an encoding issue… how to unriddle it?
  • The tip!

Courtesy of: Batman Wikia Com

Author: Michelle Homes

Courtesy of: Batman Wikia Com

In preparation for Tricia and my joint paper at SAS® Global Forum 2014, “SAS Admins Need a Dashboard Too” our SAS admin support team, Ken Aanderud and Paul Homes  had been busy setting up our new SAS Visual Analytics 6.3 environments, which we are very excited about! As we got underway loading tables to explore and analyze data we came across an error that prevented a table to be  loaded into memory:

ERROR: Some character data was lost during transcoding in the dataset LIB.TABLE. Either the data contains characters that are not representable in the new encoding or truncation occurred during transcoding.

The log message indicated Cross Environment Data Access (CEDA) was being used:

NOTE: Data file LIB.TABLE.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance.

So we had an encoding issue… how to unriddle it?

Being Base SAS programmers we looked to our trusty PROC CONTENTS to interrogate the descriptor portion of a SAS dataset that shows the table encoding value. The PROC CONTENTS output showed the table was in latin1 format and the default system encoding for the SAS Visual Analytics 6.3 installation was utf8 so our next step was to convert them.

The tip!

The following is the code was used to do the conversion and the tip is to use the CVP (character variable padding) engine on the LIBNAME statement…

libname l1 cvp './data.latin1' inencoding=latin1;
libname u8 './data' outencoding=utf8;
proc copy in=l1 out=u8 noclone;
run;

If you’d like to know more about the CVP engine and encoding some useful references you may want to check out are:

  • SAS(R) 9.4 National Language Support (NLS): Reference Guide, Second Edition
    Avoiding Character Data Truncation By Using the CVP Engine

    http://support.sas.com/documentation/cdl/en/nlsref/67110/HTML/default/viewer.htm#p00fhxufzmc274n19xax2hllvin4.htm

  • SUGI28 Paper 281-28  Multi-Lingual Computing with the SAS® 9.1 Unicode Server, Stephen Beatrous, SAS Institute Cary, NC  http://www2.sas.com/proceedings/sugi28/281-28.pdf

Have you come across any encoding issues that you’ve unriddled? If so, how? Please share in the comments below.

TAGGED:sas
Share This Article
Facebook Pinterest LinkedIn
Share

Follow us on Facebook

Latest News

Flat editorial illustration: The article is about joining public web signals with internal business metrics so BI teams can inter
Alternative Data in BI: Bringing Public Web Data Into Your Dashboards
Big Data Business Intelligence Exclusive Web Analytics
Flat editorial illustration: A SaaS-editorial scene showing product usage, support patterns, and renewal feedback informing a fle
Using Product Usage Analytics and Support Data to Build a B2B Product Roadmap
Business Intelligence Infographic
From Hiring To Payroll: Managing HR Data Across Business Systems -- AI-generated illustration
From Hiring To Payroll: Managing HR Data Across Business Systems
Big Data Business Intelligence Infographic
Flat editorial illustration: The article is about automating the collection, preparation, and delivery of marketing data across p
From Data to Dashboards: 5 Marketing Reporting Automation Software Picks
Analytics Business Intelligence Exclusive Marketing

Stay Connected

1.2KFollowersLike
33.7KFollowersFollow
222FollowersPin

You Might also Like

Analytics Valley: Big Data, Data Scientists and SAS Programmers
AnalyticsHadoopOpen Source

Analytics Valley: Big Data, Data Scientists and SAS Programmers

5 Min Read
Rescue Squad – A Validation of Performance Management Software
Business IntelligenceCRMPredictive Analytics

Rescue Squad – A Validation of Performance Management Software

3 Min Read
Why Do Once Successful Companies Fail?
Uncategorized

Why Do Once Successful Companies Fail?

7 Min Read
A business intelligence parable
Business IntelligenceData Warehousing

A business intelligence parable

6 Min Read

SmartData Collective is one of the largest & trusted community covering technical content about Big Data, BI, Cloud, Analytics, Artificial Intelligence, IoT & more.

Chatbots and SEO: How Can Chatbots Improve Your SEO Ranking?
Chatbots and SEO: How Can Chatbots Improve Your SEO Ranking?
Artificial Intelligence Chatbots Exclusive
How To Get An Award Winning Giveaway Bot
How To Get An Award Winning Giveaway Bot
Big Data Chatbots Exclusive

Quick Link

  • About
  • Contact
  • Privacy
Follow US
© 2008-26 SmartData Collective. All Rights Reserved.
Welcome Back!

Sign in to your account

Username or Email Address
Password

Lost your password?