BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
Rakeon
Quartz | Level 8

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?

1 ACCEPTED SOLUTION

Accepted Solutions
1 REPLY 1
Tom
Super User Tom
Super User

That looks like a bug. Open a ticket with SAS support.

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 814 views
  • 1 like
  • 2 in conversation