topic Re: measuring space occupied by sas data sets in a given directory??? in SAS Procedures

measuring space occupied by sas data sets in a given directory???

sassharp — Fri, 21 Dec 2012 05:06:56 GMT

Need to measure space occupied by SAS data sets in a given directory(x) and need to generate report every day in excel or email??

Obstacle: dont have permission to read every sub directory under given directory (x)?

But have sudo privileges in command prompt to a given directory (x).

Q) Can we done this task using SAS management console?

Using scripting only?

Any literature appreciated.

I saw some paper or tip to do this in SAS.com Now not able to find that paper or tip. Share if you have that paper.

Thanks.

Re: measuring space occupied by sas data sets in a given directory???

Prit — Fri, 21 Dec 2012 06:58:31 GMT

One way to find the details of space occupied by sas datset by using "PROC CONTENTS".

Refer below sample code which may help you.

Libname Test "<PATH>";

Proc Contents DATA=Test._all_ nods;

run;

Re: measuring space occupied by sas data sets in a given directory???

Ksharp — Fri, 21 Dec 2012 07:27:23 GMT

What engine are you using ?

If BASE then you can query the dictionary table like above did.

If SPDS then you can use command du -g .

Re: measuring space occupied by sas data sets in a given directory???

LinusH — Fri, 21 Dec 2012 13:04:23 GMT

In dictionary.tables, there is also a column specifying level compression, which can be used in the calculation.

If you have table in place deletions, beware to use no of physical observations.

What is missing here is size information of indexes, which could be complicated to calculate.

So, bottom line, using OS tools is preferable if you need a result close as possible to the "truth".

Re: measuring space occupied by sas data sets in a given directory???

sassharp — Fri, 21 Dec 2012 16:23:15 GMT

Still looking for effecient answers.

Re: measuring space occupied by sas data sets in a given directory???

Ksharp — Mon, 24 Dec 2012 01:33:25 GMT

The efficient way is to use OS command as Linux did .

What engine are you using .BASE engine can query dictionary table to find out the size , but SPDS can't .

The attachement is a paper I wrote for SGF next year. But it is still not adopted .Hope it can help you a little bit. I used OS command to get SPDS library's size ,very fast. you can try it.

Ksharp