https://communities.sas.com/t5/SAS-Programming/SAS-Data-Integration-4-902-Remove-options-compress-yes-from-quot/m-p/821699#M324407 <P>That looks like a bug. Open a ticket with SAS support.</P> Tue, 05 Jul 2022 20:03:20 GMT Tom 2022-07-05T20:03:20Z https://communities.sas.com/t5/SAS-Programming/SAS-Data-Integration-4-902-Remove-options-compress-yes-from-quot/m-p/821624#M324385 <P>Hi,&nbsp;</P> <P>I use SAS Data Integration in order to append some data.<BR />I would like to use the transformation "Insert Rows", but actually it puts automatically the options "COMPRES=YES" in data output.<BR />When I run the job, SAS DI shows this warning:</P> <P>&nbsp;</P> <PRE>461 /*---- Insert rows into target table ----*/ 462 proc sql; 463 insert into inp.out_v ( 464 COMPRESS = YES, 465 V1, V2, V3, V4, V5 466 ) 19 The SAS System 16:38 Tuesday, July 5, 2022 467 select 468 W7FCUX5.V1 length = 8 469 label = 'V1', 470 W7FCUX5.V2 length = 32 471 label = 'V2', 472 W7FCUX5.V3 length = 3 473 label = 'V3', 474 W7FCUX5.V4 length = 255 475 label = 'V4', 476 W7FCUX5.V5 length = 255 477 label = 'V5' 478 from 479 work.W7FCUX5 as W7FCUX5 480 ; 481 quit; 482 483 %global etls_sql_pushDown; 484 %let etls_sql_pushDown = &amp;sys_sql_ip_all; 485 486 %rcSet(&amp;sqlrc); 487 488 %mend etls_sql_insert_rows; 489 490 /* execute etls_sql_insert_rows */ 491 %etls_sql_insert_rows; WARNING: The option COMPRESS is not valid in this context. Option ignored. WARNING: The option COMPRESS is not valid in this context. Option ignored.</PRE> <P>Is there a way to remove this warning?</P> Tue, 05 Jul 2022 14:59:13 GMT https://communities.sas.com/t5/SAS-Programming/SAS-Data-Integration-4-902-Remove-options-compress-yes-from-quot/m-p/821624#M324385 Rakeon 2022-07-05T14:59:13Z https://communities.sas.com/t5/SAS-Programming/SAS-Data-Integration-4-902-Remove-options-compress-yes-from-quot/m-p/821699#M324407 <P>That looks like a bug. Open a ticket with SAS support.</P> Tue, 05 Jul 2022 20:03:20 GMT https://communities.sas.com/t5/SAS-Programming/SAS-Data-Integration-4-902-Remove-options-compress-yes-from-quot/m-p/821699#M324407 Tom 2022-07-05T20:03:20Z