04-25-2018 05:20 PM
Hello, I'm trying to convert a variable that is stored as a BIGINT from a Neteeza database to a character data type and have not had much luck in doing so. I'm trying to convert this data type in a join without using a pass-through query and was wondering if this is possible.
Table1 as t1 Inner Join Table2 as t2 on t1.ID = put(t2.ID,20.)
Have to convert to a character with a length of 20. Received errors with this piece of code.
Thanks in advance.
04-25-2018 06:41 PM
Please post the relevant section from your log or at least the full error message.
If you say pass-through: Implicit or explicit?
If explicit then you need to use Netezza functions - to_char()
If implicit then be aware that the SAS put() function gets eventually not pushed to the data base meaning that SAS will pull all the data first into SAS before applying the join condition.
According to docu SAS can deal with Bigint and the put() function as such should work. So please show us some log so we can better understand what's going wrong.
05-03-2018 04:54 PM