topic Re: Scan sas jobs for the table inserts in SAS Programming

Scan sas jobs for the table inserts

sundeep23 — Tue, 20 Oct 2015 22:02:41 GMT

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.

Re: Scan sas jobs for the table inserts

RW9 — Wed, 21 Oct 2015 09:37:03 GMT

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.

Re: Scan sas jobs for the table inserts

LinusH — Wed, 21 Oct 2015 10:46:42 GMT

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.

Re: Scan sas jobs for the table inserts

sundeep23 — Wed, 21 Oct 2015 15:12:59 GMT

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.