Hello everyone! Sorry if I picked the wrong component for this, but my question has to do with SAS CIS as well as SAS programming and Oracle interaction. I have a calculated item in SAS CIS which contains the input function converting a string type DB table field into a number. It goes something like this: input (<table>.field_1, 20.0) Because of this, export nodes containing this calculated item as one of their export fields can't pass the resulting query to Oracle, the query is processed in WORK and it ends up too heavy for our resources. Does anyone know of a solution I can use inside a calculated item in order to convert a string value into a number that can be passed to Oracle 12c? As far as I understand, you can't use purely Oracle functions (to_number etc) in calculated items, can't pass purely SAS functions to Oracle and I haven't been able to find a solution that works in both environments.
... View more