It is very interesting when I pull data from Netezza. I got message 'ERROR: Unable to transcode data'. For what I see, the char variable are defined with big length such as $1000. If I use TRIM(var1) as var_1 length=20 for example, the message went way and I can pull this variable without a problem, but this solution doesn't solve the issues for other variables that have the same error message. Does anyone else have the same problem before?
Thank you!
Yvonne
This is a known problem. What version and maintenance release of SAS are you using - compare it to the versions in this link:
http://support.sas.com/kb/59/905.html
This is a known problem. What version and maintenance release of SAS are you using - compare it to the versions in this link:
http://support.sas.com/kb/59/905.html
Thank you, SASKiwi!
Yes, I submited a ticket to IT people but just curious why I can read some variables that have error by shorten their length.
The link shows some SAS releases have a fix that can be applied. This is the best way to fix the problem.
Here are the partial contents from SAS
The CONTENTS Procedure
Data Set Name address Observations .
Member Type DATA Variables 60
Engine NETEZZA Indexes 0
Created . Observation Length 0
Last Modified . Deleted Observations 0
Protection Compressed NO
Data Set Type Sorted NO
Label
Data Representation Default
Encoding Default
Variables in Creation Order
# Variable Type Len Format Informat
4 address_1 Char 1000 $1000. $1000.
5 address_2 Char 1000 $1000. $1000.
6 city Char 1000 $1000. $1000.
7 state Char 200 $200. $200.
8 postal Char 200 $200. $200.
9 county Char 80 $80. $80.
10 country Char 12 $12. $12.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.