Cookies help us display personalized product recommendations and ensure you have great shopping experience.

By using this site, you agree to the Privacy Policy and Terms of Use.
Accept
SmartData CollectiveSmartData Collective
  • Analytics
    AnalyticsShow More
    data analytics and truck accident claims
    How Data Analytics Reduces Truck Accidents and Speeds Up Claims
    7 Min Read
    predictive analytics for interior designers
    Interior Designers Boost Profits with Predictive Analytics
    8 Min Read
    image fx (67)
    Improving LinkedIn Ad Strategies with Data Analytics
    9 Min Read
    big data and remote work
    Data Helps Speech-Language Pathologists Deliver Better Results
    6 Min Read
    data driven insights
    How Data-Driven Insights Are Addressing Gaps in Patient Communication and Equity
    8 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
SHARE

Author: Michelle Homes

Contents
So we had an encoding issue… how to unriddle it?The tip!
Batman's Riddler

Courtesy of: Batman Wikia Com

Author: Michelle Homes

Batman's Riddler

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

data analytics and truck accident claims
How Data Analytics Reduces Truck Accidents and Speeds Up Claims
Analytics Big Data Exclusive
predictive analytics for interior designers
Interior Designers Boost Profits with Predictive Analytics
Analytics Exclusive Predictive Analytics
big data and cybercrime
Stopping Lateral Movement in a Data-Heavy, Edge-First World
Big Data Exclusive
AI and data mining
What the Rise of AI Web Scrapers Means for Data Teams
Artificial Intelligence Big Data Exclusive

Stay Connected

1.2kFollowersLike
33.7kFollowersFollow
222FollowersPin

You Might also Like

SAS commits $70 million to Cloud Computing

4 Min Read

Neil Raden’s thoughts on Business Analytics vs Business Intelligence

4 Min Read

First Look – SAS In-Database Analytics

6 Min Read

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.

data-driven web design
5 Great Tips for Using Data Analytics for Website UX
Big Data
AI and chatbots
Chatbots and SEO: How Can Chatbots Improve Your SEO Ranking?
Artificial Intelligence Chatbots Exclusive

Quick Link

  • About
  • Contact
  • Privacy
Follow US
© 2008-25 SmartData Collective. All Rights Reserved.
Go to mobile version
Welcome Back!

Sign in to your account

Username or Email Address
Password

Lost your password?