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.

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
  • 925 views
  • 1 like
  • 2 in conversation