DSXchange

Thanks guys.

The AsFloat solution works fine.

Thanks Naveen.

I have tried using the 46528/86400 and the Div syntax and both return the same zero result.

I acheived this as follows: create a PX job comprising a SAS stage with the following code (where values enclosed in # are job parameters representing the SAS library and dataset): libname saslib "#saslibname#"; data liborch.in_data; set saslib.#dataset_in# (obs=0); run; and direct the out...

The following division in a Transformer stage results in zero.

Div(46528,86400)

Expected result = 0.538518519

I have tried data types (Length = 40, Scale = 30) of Decimal, Double, Float and Numeric without success.

Any help would be appreciated.

When using the 'MCP' function with Iconv / Oconv what is the ASCII range within which characters are deemed printable? And hence outside of which characters would be converted to full stop (period)?

Thanks in anticipation.