macro to check if teradata has been called in a sas code

Reply
New Contributor
Posts: 2

macro to check if teradata has been called in a sas code

Hi Everyone,

I have to write a code to check which code has called teradata query and also copy that query if possible..

Want to write a macro and evry code  will have that macro at the top.. kind of an audit macro.

will have to chase the log while the code is running.

Please help..

Thanks in advance.

DeepakPara

New Contributor
Posts: 2

Re: macro to check if teradata has been called in a sas code

basically I wana search 'Teradata' or maybe anyother string at run time.
Super User
Super User
Posts: 6,356

Re: macro to check if teradata has been called in a sas code

It might be easier to search the query logs in your Teradata server.

Otherwise you might want to tell all of your SAS programmers to add options that will insure that messages from Teradata appear in the log. Then there will be more things to search for in the log.

 

options sastrace=',,,ds' sastraceloc=saslog ;
Esteemed Advisor
Posts: 6,684

Re: macro to check if teradata has been called in a sas code

Look at the log of a job that you know uses the Teradata connection.

Find a characteristic string that is typical for that (say, a schema name or similar).

Use grep with that string on all your logs.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Ask a Question
Discussion stats
  • 3 replies
  • 91 views
  • 0 likes
  • 3 in conversation