Macros for SAS Application Developers
https://github.com/sasjs/core
Loading...
Searching...
No Matches
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_refThe 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

Related Macros

Version
9.2
Author
Allan Bowe

Definition in file mp_coretable.sas.