topic Re: Proc append hide warnings in SAS Programming

Proc append hide warnings

SASAna — Wed, 20 May 2020 17:55:22 GMT

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

Re: Proc append hide warnings

Quentin — Wed, 20 May 2020 18:13:32 GMT

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.

Re: Proc append hide warnings

Kurt_Bremser — Wed, 20 May 2020 18:34:32 GMT

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

Re: Proc append hide warnings

s_lassen — Wed, 20 May 2020 19:29:43 GMT

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).

Re: Proc append hide warnings

Ksharp — Thu, 21 May 2020 11:15:15 GMT

Do you try PROC SQL + INSERT INTO ?