hi,
I need to run a query of historical bank transactions, in Hadoop. I usually query in Netezza.
I received the following error, and was wondering if anyone had a tip to offer.
NOTE: Updated analytical products:
SAS/STAT 14.1
SAS/ETS 14.1
SAS/OR 14.1
SAS/IML 14.1
SAS/QC 14.1
NOTE: Additional host information:
IBM AIX AIX 64 1 7 00C030A74C00
Thank you
There seems to be corrupt/invalid data in the file.
Does the query work outside of SAS? Is the data in text files? Are the text files UTF-8? Can they be UTF8? Can you run a validation?
thanks for ur reply. I ended running the variable but excluding a variable. The output was good.I didn't look further into this. A colleague later gave me, which i'm listing here in case in can help anyone:
Pls add this option in libname statement
DBMAX_TEXT=255 TRANSCODE_FAIL=SILENT LOGIN_TIMEOUT= 0 ;
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.