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.

SAS Innovate 2025: Call for Content

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 16. Read more here about why you should contribute and what is in it for you!

Submit your idea!

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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