Formats in SAS and Oracle

[dimpu79]

Hi,
If we are having variables in sas formats and we need to load the sas datasets on Oracle, how can we do this if variable formats in sas are not compatible with that of oracle.
Thanks in advance.

 

[klaz2002]

Why not 'strip' the formats off the variables and then load the raw data into Oracle. You may still have to work on date and time vars but all other vars should be ok.

ex.
data your_table_to_export_to_oracle;
set your_table;
format _all_;
run;


The new table should have no formats attached.

I hope that this helps you.


Klaz