Hi,
I have a requirement to copy some oracle data from one table to another using SAS.
I am using the following libname statement to retrieve the oracle tables present in the schema-uuu
Libname xxx ORACLE USER=yyy PASSWORD=vvv SCHEMA=uuu PATH=www;
One of my Oracle table has a field with data type as float. But when they are transformed to a SAS dataset, this field is transformed to a numeric variable with format best12. . As a result the value .00000081147986 in oracle table becomes 8.1147986E-6 in the sas dataset.
Is there a way by which I can specify the format of a numeric value in the libname statement to make it best22. similar to DBMAX_TEXT option.
Thanks in advance!