macros Directory Reference

Data Controller Macros for all SAS Flavours.

Files

file  bitemporal_closeouts.sas [code]
 Closes out records.
 
file  bitemporal_dataloader.sas [code]
 Routine supporting multiple load types.
 
file  bitemporal_dataloader.test.1.sas [code]
 Test Harness for bitemporal dataloader.
 
file  bitemporal_dataloader.test.2.sas [code]
 Test Harness for bitemporal dataloader.
 
file  bitemporal_dataloader.test.3.sas [code]
 Test Harness for bitemporal dataloader.
 
file  bitemporal_dataloader.test.4.sas [code]
 Test Harness for bitemporal dataloader - deletes only.
 
file  mpe_accesscheck.sas [code]
 Checks group access level for a table or library.
 
file  mpe_accesscheck.test.sas [code]
 Testing mpe_accesscheck macro.
 
file  mpe_alerts.sas [code]
 send alerts
 
file  mpe_checkrestore.sas [code]
 Checks if a user is able to restore a LOAD_REF.
 
file  mpe_checkrestore.test.sas [code]
 Testing mpe_checkrestore macro.
 
file  mpe_columnlevelsecurity.sas [code]
 Filters a table with CLS rules.
 
file  mpe_dsmeta.sas [code]
 Gets table metadata.
 
file  mpe_dsmeta.test.sas [code]
 Testing mpe_dsmeta macro.
 
file  mpe_filtermaster.sas [code]
 dynamic where clause creation
 
file  mpe_filtermaster.test.1.sas [code]
 setup mpe_filtermaster RLS test
 
file  mpe_filtermaster.test.sas [code]
 setup mpe_filtermaster macro test
 
file  mpe_getgroups.sas [code]
 Gets groups from metadata and augments with DC groups.
 
file  mpe_getlabels.sas [code]
 Gets the table and column labels for a particular table.
 
file  mpe_getvars.sas [code]
 Takes a input table and makes every variable a macro variable.
 
file  mpe_getversions.sas [code]
 Get previous versions of a table.
 
file  mpe_getversions.test.sas [code]
 Testing mpe_getversions macro.
 
file  mpe_loader.sas [code]
 Loads CSV and sends to the staging area for approval.
 
file  mpe_loadfail.sas [code]
 Updates the mpe_loads tracking table with success / failure info.
 
file  mpe_makedata.sas [code]
 Populates the Data Controller tables with sample data.
 
file  mpe_makedatamodel.sas [code]
 Creates the empty Data Controller tables.
 
file  mpe_makesampledata.sas [code]
 Creates sample data for DC and updates MPE_TABLES.
 
file  mpe_refreshlibs.sas [code]
 Refreshes the library data catalog.
 
file  mpe_refreshtables.sas [code]
 Refreshes the data catalog.
 
file  mpe_runhook.sas [code]
 Runs a hook from MPE_TABLES.
 
file  mpe_targetloader.sas [code]
 Generic loader for tables configured in &mpelib..mpe_tables.
 
file  mpe_validatefilter.sas [code]
 Validates a filter clause and updates the source tables.
 
file  mpe_xlmapvalidate.sas [code]
 Validates excel map structure and adds load ref.
 
file  mpe_xlmapvalidate.test.sas [code]
 Testing mpe_xlmapvalidate macro.
 
file  mpeinit.sas [code]
 Initialisation file for Data Controller- sets SASAUTOs etc.
 
file  mpeinit2.sas [code]
 Helper macro to enable interactive debugging.
 
file  mpeterm.sas [code]
 Termination file for the 4GL Apps Editor.
 
file  removecolsfromwork.sas [code]
 Temp fix to remove md5 content from tables.