Actually the data for account id is wrong in the source file itself.It should be a numeric value but is coming as a character. More on teh background: An XML file line is fed into a column in teradata table(used as source to SAS dataset). In SAS that column is parsed using a macro and ACOOUNT value in xml is assigned to numeric variable ACCOUNT. But the xml data 9d100 in TD is converted to 9e100 in sas and we are having question on why the difference in value. My question is what is the logic behind 9d100 being converted to 9e100 as we need to explain why the value is difefrent. ACCOUNT column cannot be converted to character as it is inherently numeric.When there is a invalid value it should be same in Teradata and source ideally.
... View more
