mp_getformats.sas File Reference

Export format definitions. More...

Go to the source code of this file.

Detailed Description

Formats are exported from the first (if any) catalog entry in the FMTSEARCH path.

Formats are taken from the library / dataset reference and / or a static format list.

Note - the source for this information is the dictionary.formats table. This cannot show formats that are not already declared in the FMTSEARCH path.

Example usage:

%mp_getformats(lib=sashelp,ds=prdsale,outsummary=work.dictable)

%mp_getformats(fmtlist=FORMAT1 $FORMAT2 @INFMT3,outsummary=work.table2)

Parameters

[in]

lib=

(0) The libref for which to return formats.

Todo

Enable exporting of formats for an entire library

Parameters

[in]	ds=	(0) The dataset from which to obtain format definitions
[in]	fmtlist=	(0) A list of additional format names
[out]	outsummary=	(work.mp_getformats_summary) Output dataset containing summary definitions - structure taken from dictionary.formats as follows:

libname:$8.	memname:$32.	path:$1024.	objname:$32.	fmtname:$32.	fmttype:$1.	source:$1.	minw:best.	mind:best.	maxw:best.	maxd:best.	defw:best.	defd:best.
				$	F	B	1	0	32767	0	1	0
				$	I	B	1	0	32767	0	1	0
		/opt/sas/sas9/SASHome/SASFoundation/9.4/sasexe	UWIANYDT	$ANYDTIF	I	U	1	0	60	0	19	0
		/opt/sas/sas9/SASHome/SASFoundation/9.4/sasexe	UWFASCII	$ASCII	F	U	1	0	32767	0	1	0
		/opt/sas/sas9/SASHome/SASFoundation/9.4/sasexe	UWIASCII	$ASCII	I	U	1	0	32767	0	1	0
		/opt/sas/sas9/SASHome/SASFoundation/9.4/sasexe	UWFBASE6	$BASE64X	F	U	1	0	32767	0	1	0

Parameters

[out]

outdetail=

(0) Provide an output dataset in which to export all the custom format definitions (from proc format CNTLOUT). Definitions: https://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/viewer.htm#a002473477.htm Sample data:

FMTNAME:$32.	START:$16.	END:$16.	LABEL:$256.	MIN:best.	MAX:best.	DEFAULT:best.	LENGTH:best.	FUZZ:best.	PREFIX:$2.	MULT:best.	FILL:$1.	NOEDIT:best.	TYPE:$1.	SEXCL:$1.	EEXCL:$1.	HLO:$13.	DECSEP:$1.	DIG3SEP:$1.	DATATYPE:$8.	LANGUAGE:$8.
WHICHPATH	0	0	path1	1	40	28	28	1E-12		0		0	N	N	N
WHICHPATH	**OTHER**	**OTHER**	big fat problem if not path1	1	40	28	28	1E-12		0		0	N	N	N	O

SAS Macros

• mddl_sas_cntlout.sas
• mf_dedup.sas
• mf_getfmtlist.sas
• mf_getfmtname.sas
• mf_getquotedstr.sas
• mf_getuniquename.sas

Related Macros

• mf_getfmtlist.sas
• mp_applyformats.sas
• mp_cntlout.sas
• mp_getformats.test.sas

Version

9.2

Author

Allan Bowe

Definition in file mp_getformats.sas.