By using this site, you agree to the Privacy Policy and Terms of Use.
Accept
SmartData Collective
  • Analytics
    AnalyticsShow More
    data-driven image seo
    Data Analytics Helps Marketers Substantially Boost Image SEO
    8 Min Read
    construction analytics
    5 Benefits of Analytics to Manage Commercial Construction
    5 Min Read
    benefits of data analytics for financial industry
    Fascinating Changes Data Analytics Brings to Finance
    7 Min Read
    analyzing big data for its quality and value
    Use this Strategic Approach to Maximize Your Data’s Value
    6 Min Read
    data-driven seo for product pages
    6 Tips for Using Data Analytics for Product Page SEO
    11 Min Read
  • Big Data
  • BI
  • Exclusive
  • IT
  • Marketing
  • Software
Search
© 2008-23 SmartData Collective. All Rights Reserved.
Reading: SAS Visual Analytics: Tips for Unriddling Encoding in SAS Visual Analytics 6.3
Share
Notification Show More
Latest News
anti-spoofing tips
Anti-Spoofing is Crucial for Data-Driven Businesses
Security
ai in software development
3 AI-Based Strategies to Develop Software in Uncertain Times
Software
ai in ppc advertising
5 Proven Tips for Utilizing AI with PPC Advertising in 2023
Artificial Intelligence
data-driven image seo
Data Analytics Helps Marketers Substantially Boost Image SEO
Analytics
ai in web design
5 Ways AI Technology Has Disrupted Website Development
Artificial Intelligence
Aa
SmartData Collective
Aa
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
Last updated: 2014/01/21 at 11:00 AM
Tricia Aanderud
3 Min Read
SHARE
- Advertisement -

Author: Michelle Homes

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

- Advertisement -

Courtesy of: Batman Wikia Com

Author: Michelle Homes

More Read

Building a SAS Stored Process Log

SAS Visual Analytics: How Catwoman Influenced My Data
SAS Visual Analytics: What’s Happening to SAS BI?
Big Data and Rise of Predictive Analytics
SAS Stored Process Errors: Three Common Issues to Avoid
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:

- Advertisement -

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…

- Advertisement -

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.

- Advertisement -
TAGGED: sas
Tricia Aanderud January 21, 2014
Share this Article
Facebook Twitter Pinterest LinkedIn
Share
- Advertisement -

Follow us on Facebook

Latest News

anti-spoofing tips
Anti-Spoofing is Crucial for Data-Driven Businesses
Security
ai in software development
3 AI-Based Strategies to Develop Software in Uncertain Times
Software
ai in ppc advertising
5 Proven Tips for Utilizing AI with PPC Advertising in 2023
Artificial Intelligence
data-driven image seo
Data Analytics Helps Marketers Substantially Boost Image SEO
Analytics

Stay Connected

1.2k Followers Like
33.7k Followers Follow
222 Followers Pin

You Might also Like

Building a SAS Stored Process Log

10 Min Read
What is Data Pipeline A detailed explaination
AnalyticsBig Data

SAS Visual Analytics: How Catwoman Influenced My Data

7 Min Read

SAS Visual Analytics: What’s Happening to SAS BI?

7 Min Read
big data and predictive analytics
AnalyticsBest PracticesBig DataBusiness IntelligenceCRMData ManagementData WarehousingInside CompaniesITMarket ResearchMarketingPolicy and GovernancePredictive AnalyticsSocial DataSocial Media AnalyticsSoftwareWeb Analytics

Big Data and Rise of Predictive Analytics

5 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 in ecommerce
Artificial Intelligence for eCommerce: A Closer Look
Artificial Intelligence

Quick Link

  • About
  • Contact
  • Privacy
Follow US

© 2008-23 SmartData Collective. All Rights Reserved.

Removed from reading list

Undo
Go to mobile version
Welcome Back!

Sign in to your account

Lost your password?