Hi,
I use SAS Data Integration in order to append some data.
I would like to use the transformation "Insert Rows", but actually it puts automatically the options "COMPRES=YES" in data output.
When I run the job, SAS DI shows this warning:
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 = &sys_sql_ip_all; 485 486 %rcSet(&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.
Is there a way to remove this warning?
That looks like a bug. Open a ticket with SAS support.
That looks like a bug. Open a ticket with SAS support.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.