Scan sas jobs for the table inserts

[sundeep23]

HI All,

 I am trying to scan through the sas codes to read the number of datasets that are updating the oracle tables . I need some ideas to start with do I need to the string check for "proc db load" or for " prosql insert in to"  or is there any better way to scan. Thanks for your help.

[RW9]

Sorry, there's not much information there.  What "jobs", what software etc?  Personally I don't like the idea of people updating databases from SAS.  You could try searching logs for the connect to oracle information, e.g in:

proc sql;

  connect to oracle (path=....);

However, the question arises why?  It sounds like giving the freedom to do this has got a bit out of control, me I would put in place a system where tracked imports, or code is run, preferably at set points and under certain conditions.  Would make tracking a whole lot easier.

[LinusH]

To do this the proper way you need metadata. And that is available in the SAS offering Data Integration Server.
Scanning through program files and logs is a poor routine as a system management solution.

[sundeep23]

Thanks for your responses we are trying to create a metadata thats the reason I was trying to scan through logs and see which sas programs are inserting data in to database tables. I'll see if we have DI studio and go from there.