06-09-2017 10:32 PM
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?
06-09-2017 11:04 PM
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.
Need further help from the community? Please ask a new question.