Export dataset metadata to a single output table. More...

Detailed Description

Exports the dataset attributes and enginehost information, then converts the datasets into a single output table in the following format:

ODS_TABLE:$10.	NAME:$100.	VALUE:$1000.
`ATTRIBUTES`	`Data Set Name`	`SASHELP.CLASS`
`ATTRIBUTES`	`Observations`	`19`
`ATTRIBUTES`	`Member Type`	`DATA`
`ATTRIBUTES`	`Variables`	`5`
`ATTRIBUTES`	`Engine`	`V9`
`ATTRIBUTES`	`Indexes`	`0`
`ATTRIBUTES`	`Created`	`06/08/2020 00:59:14`
`ATTRIBUTES`	`Observation Length`	`40`
`ATTRIBUTES`	`Last Modified`	`06/08/2020 00:59:14`
`ATTRIBUTES`	`Deleted Observations`	`0`
`ATTRIBUTES`	`Protection`	`.`
`ATTRIBUTES`	`Compressed`	`NO`
`ATTRIBUTES`	`Data Set Type`	`.`
`ATTRIBUTES`	`Sorted`	`NO`
`ATTRIBUTES`	`Label`	`Student Data`
`ATTRIBUTES`	`Data Representation`	`SOLARIS_X86_64, LINUX_X86_64, ALPHA_TRU64, LINUX_IA64`
`ATTRIBUTES`	`Encoding`	`us-ascii ASCII (ANSI)`
`ENGINEHOST`	`Data Set Page Size`	`65536`
`ENGINEHOST`	`Number of Data Set Pages`	`1`
`ENGINEHOST`	`First Data Page`	`1`
`ENGINEHOST`	`Max Obs per Page`	`1632`
`ENGINEHOST`	`Obs in First Data Page`	`19`
`ENGINEHOST`	`Number of Data Set Repairs`	`0`
`ENGINEHOST`	`Filename`	`/opt/sas/sas9/SASHome/SASFoundation/9.4/sashelp/class.sas7bdat`
`ENGINEHOST`	`Release Created`	`9.0401M7`
`ENGINEHOST`	`Host Created`	`Linux`
`ENGINEHOST`	`Inode Number`	`28314616`
`ENGINEHOST`	`Access Permission`	`rw-r--r--`
`ENGINEHOST`	`Owner Name`	`sas`
`ENGINEHOST`	`File Size`	`128KB`
`ENGINEHOST`	`File Size (bytes)`	`131072`

Example usage:

%mp_dsmeta(sashelp.class,outds=work.mymeta)
proc print data=work.mymeta;
run;

For more details on creating datasets from PROC CONTENTS check out this excellent paper by Louise Hadden.

Parameters

[in]	libds	The library.dataset to export the metadata for
[out]	outds=	(work.dsmeta) The output table to contain the metadata

Definition in file mp_dsmeta.sas.