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

@sasjslint {"maxLineLength": 95}

Definition in file mp_dsmeta.sas.