Macros for SAS Application Developers
https://github.com/sasjs/core
Loading...
Searching...
No Matches
mp_dsmeta.sas File Reference

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

Go to the source code of this file.

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]libdsThe library.dataset to export the metadata for
[out]outds=(work.dsmeta) The output table to contain the metadata

Related Files

Definition in file mp_dsmeta.sas.