mp_coretable.sas File Reference

Create the permanent Core tables. More...

Go to the source code of this file.

Detailed Description

Several macros in the core library make use of permanent tables. To avoid duplication in definitions, this macro provides a central location for managing the corresponding DDL.

Note - this macro is likely to be deprecated in future in favour of a dedicated "datamodel" folder (prefix mddl)

Any corresponding data would go in a seperate repo, to avoid this one ballooning in size!

Example usage:

%mp_coretable(LOCKTABLE,libds=work.locktable)

Parameters

[in]	table_ref	The type of table to create. Example values: DIFFTABLE FILTER_DETAIL FILTER_SUMMARY LOCKANYTABLE MAXKEYTABLE
[in]	libds=	(0) The library.dataset reference used to create the table. If not provided, then the DDL is simply printed to the log.

SAS Macros

• mddl_dc_difftable.sas
• mddl_dc_filterdetail.sas
• mddl_dc_filtersummary.sas
• mddl_dc_locktable.sas
• mddl_dc_maxkeytable.sas
• mf_getuniquename.sas

Related Macros

• mp_filterstore.sas
• mp_lockanytable.sas
• mp_retainedkey.sas
• mp_storediffs.sas
• mp_stackdiffs.sas

Version

9.2

Author

Allan Bowe

Definition in file mp_coretable.sas.