topic SAS DI Folder Datasets and their Size and location information in SAS Data Management

SAS DI Folder Datasets and their Size and location information

vickys — Thu, 05 Aug 2021 05:09:26 GMT

HI Experts,

we in the process of migration and I came across a situation where I need to Find all the Datasets in particular Folder in SAS DI and their Size as well.

I have generated a report in SAS DI but its giving all the information on jobs , Tables, and columns etc.

I am looking for the datasets present in particular folder, Dataset path and Datasets Size.

Could someone please share some info if they have idea.

Really appreciate it.

Thanks,

Vicks

Re: SAS DI Folder Datasets and their Size and location information

AllanBowe — Sat, 07 Aug 2021 18:45:14 GMT

When you say folder, I'm presuming you mean a physical directory (not metadata folder).

The following macro will give you what you need: https://core.sasjs.io/mp__dirlist_8sas.html

Use the `getattrs` parameter to get additional (size) info, eg as follows:

%mp_dirlist(path=/your/folder,outds=work.results,getattrs=YES)

If you're looking to simply grab the size of a single dataset you can also use this macro function: https://core.sasjs.io/mf__getfilesize_8sas.html