Proc append hide warnings

[SASAna]

Hi SAS users,

I am loading SAS dataset to ORacle table of around 500 attributes. I am getting big list of warnings of base and data length. How to hide them to not show in the log?

Below is my proc statement and i have used NOWARN

Proc Append Base=<Oracle_table> Data=FINAL FORCE NOWARN; run;

Thanks,

Ana

[Quentin]

If it's just conflicts in variable lengths, probably would be easiest to fix the length of variables in work.final to match the length of columns in oracle_table.  

[Kurt_Bremser]

These messages have a PURPOSE. Adapt your dataset structure to that of the Oracle table when you create your dataset.

[s_lassen]

As others have remarked, the messages are there for a reason. But on the other hand, you may have character columns that are shorter that the corresponding columns in Oracle. That is not really a problem, and I agree that it can be kind of irritating to see all those messages for no other reason than that.

One fast and dirty solution could be this: modify your FINAL table to look like the Oracle table:

options compress=char; /* saves disk space when a lot of text columns are longer that necessary */

data final;
  if 0 then set <Oracle_table>; /* All the relevant variables should then have the right attributes */
  /* here goes the rest of the code to create WORK.FINAL */
  /* but excluding LENGTH statements for output variables, they are already declared */
run;

Proc append base=<Oracle_table> data=FINAL; /* FORCE should not be necessary */
run;

Or, if the final data step ends up taking too long and using too much disk space that way, you can create a data step view:

data v_FINAL/view=v_FINAL;
  if 0 then set <Oracle_table>;
  set FINAL;
run;

Proc append base=<Oracle_table> data=v_FINAL;
run;

Just make sure that you are not missing anything important by doing this (scrutinize those pesky warnings before you go fast and dirty).

[Ksharp]

Do you try PROC SQL + INSERT INTO ?