topic Re: How do I - redirect saslog to a database clob object? in SAS Community Nordic

How do I - redirect saslog to a database clob object?

jmic_nyk — Fri, 03 Feb 2023 14:03:17 GMT

Hi wise people 😍

Is it possible to redirect a saslog to a clob (or similar) object in a database - in my case Oracle?

How?

I suppose it is not possible directly, but maybe via some proc printto + proc document + ???

Any suggestions?

Would very much like to have the suggested solution to work in a batch environment on Linux using SAS9.4M7.

Re: How do I - redirect saslog to a database clob object?

Tom — Fri, 03 Feb 2023 15:24:20 GMT

Run the SAS program first. It will produce a log file like it always does.

Then use whatever command your database uses to allow you to copy an actual file into a object in the database.

Re: How do I - redirect saslog to a database clob object?

Quentin — Fri, 03 Feb 2023 15:54:42 GMT

It looks like on Viya you can use FILENAME to point to a Azure Blob Storage, so that might make it possible to create the fileref then just use PROC PRINTTO:

https://documentation.sas.com/doc/en/pgmsascdc/v_035/lestmtsglobal/p1arsjiowdszd8n1qk8mqg5p2uhv.htm

But unless there is something similar for Oracle (I doubt it), agree with suggestion to separate the process of writing the log from whatever process can upload it to the blob

Of course even if you use a non-SAS process to upload to the blob, you should still be able to call it from your SAS job (assuming XCMD is enabled), so that it is fully automated.