topic Re: SAS log with snowflake details in SAS Programming

SAS log with snowflake details

samanvi — Fri, 24 Mar 2023 16:33:13 GMT

HI All,

Need your help. We are connecting to Snowflake from SAS ( Linux) and we are exporting the log to .txt file in log we are getting a lot of data

like below

Snowflake_3:Prepared on connection 0.

But we see the above for every record insertion.

Could you help how to restrict this kind of messages in log.

Thanks & Regards

ballardw — Fri, 24 Mar 2023 17:34:32 GMT

It may help to show your current connection code so we we can see the options you have used.

samanvi — Fri, 24 Mar 2023 17:44:20 GMT

This is the connection

SASKiwi — Fri, 24 Mar 2023 21:40:24 GMT

Can you post a portion of your SAS log including your source code and some of the notes please?

Does adding this option to your LIBNAME statement help: UPDATE_MULT_ROWS=YES

Quentin — Fri, 24 Mar 2023 21:59:18 GMT

If you set:

options sastrace=off ;

do the messages go away? I think that is what the sastrace option is for.

samanvi — Tue, 28 Mar 2023 13:25:10 GMT

This even helped me Thank you