topic Finding datasets name in log directory in SAS Programming

Finding datasets name in log directory

japsas100 — Fri, 03 May 2019 19:02:50 GMT

Hi Guys,

Just wanted to check is there is fastest way to list down all the sas datasets name from number of logs stored in log directory.

My task is to find datasets name from thousand of sas logs.

Any one has sas prog to do the same teask?

Regards

Japs

Re: Finding datasets name in log directory

DMIN — Fri, 03 May 2019 19:20:28 GMT

It seems you'd better write shell scripting codes to capture these file names.

Re: Finding datasets name in log directory

japsas100 — Fri, 03 May 2019 19:24:59 GMT

Can anyone share the shell script?

Re: Finding datasets name in log directory

DMIN — Fri, 03 May 2019 19:34:20 GMT

Dataset names are either in work library or in permanent libraries, so their names should be identified by following work or other library names when creating shellscripts. Unfortunately, i don't have the scripts at hand. Hopefully other guys can help.

Re: Finding datasets name in log directory

Reeza — Fri, 03 May 2019 19:35:22 GMT

Search lexjansen.com or on here with the term 'log parsing' and you'll find examples. They definitely exist.

Re: Finding datasets name in log directory

Tom — Sat, 04 May 2019 17:18:41 GMT

You want to scan SAS logs and see what dataset names were used?

You can get a pretty good hit rated by just searching for the NOTE lines that SAS normally writes.

Start with this and perhaps fine tune it more as you see what messages it finds.

grep '^NOTE:.* data set ' *.log