https://communities.sas.com/t5/SAS-Procedures/SAS-ACCESS/m-p/26256#M5987 Hi<BR /> <BR /> I think this is a case where you should use Proc SQL Passthrough facility. It doesn't make a lot of sense to me to first load everything from Oracle into SAS only to reload it directly into another Oracle table (without any transformation steps). <BR /> <BR /> You could for example develop your code using SQLDeveloper (free tool, can be downloaded from Oracle) or TOAD. Looks like this would be a simple SQL INSERT or eventually a UPSERT.<BR /> <BR /> Once you've got working Oracle SQL you just paste it into a PROC SQL passthrough block.<BR /> <BR /> HTH<BR /> Patrick Message was edited by: Patrick Tue, 02 Nov 2010 11:40:59 GMT Patrick 2010-11-02T11:40:59Z https://communities.sas.com/t5/SAS-Procedures/SAS-ACCESS/m-p/26255#M5986 Hi, <BR /> <BR /> I have a requirement to copy some oracle data from one table to another using SAS.<BR /> <BR /> I am using the following libname statement to retrieve the oracle tables present in the schema-uuu<BR /> <BR /> Libname xxx ORACLE USER=yyy PASSWORD=vvv SCHEMA=uuu PATH=www;<BR /> <BR /> 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.<BR /> <BR /> 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.<BR /> <BR /> Thanks in advance! Tue, 02 Nov 2010 04:32:06 GMT https://communities.sas.com/t5/SAS-Procedures/SAS-ACCESS/m-p/26255#M5986 DCL 2010-11-02T04:32:06Z https://communities.sas.com/t5/SAS-Procedures/SAS-ACCESS/m-p/26256#M5987 Hi<BR /> <BR /> I think this is a case where you should use Proc SQL Passthrough facility. It doesn't make a lot of sense to me to first load everything from Oracle into SAS only to reload it directly into another Oracle table (without any transformation steps). <BR /> <BR /> You could for example develop your code using SQLDeveloper (free tool, can be downloaded from Oracle) or TOAD. Looks like this would be a simple SQL INSERT or eventually a UPSERT.<BR /> <BR /> Once you've got working Oracle SQL you just paste it into a PROC SQL passthrough block.<BR /> <BR /> HTH<BR /> Patrick Message was edited by: Patrick Tue, 02 Nov 2010 11:40:59 GMT https://communities.sas.com/t5/SAS-Procedures/SAS-ACCESS/m-p/26256#M5987 Patrick 2010-11-02T11:40:59Z