I have problems with appending a SAS Data set to an oracle table.
Connection to the Oracle-database via the LIBNAME-statement works fine, also the table definition in ORACLE fits with the format definition of my SAS-table at first view. But when I execute a PROC CONTENTS statement on the ORACLE table the column definitions are not the same as in the ORACLE definition (e.g. character 40 in SAS instead of character 30 in ORACLE and so on).
So I always receive warnings in response to my PROC APPEND statement because of different lengths on BASE and DATA files, though the definitions look OK as I mentioned above.
Hi. I've used proc append + force + nowarn and it was only partly successful. It supressed most of the warnings except for the data type mismatch (i.e. col1 in BASE has different lengths with that of DATA). Is there a way to suppress this too? Is it documented somewhere why this type of warning is not being suppressed?