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.
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
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.
Ready to level-up your skills? Choose your own adventure.