mpe_alerts.alert_lib.sas File Reference

fetch extended values for alert_lib More...

Go to the source code of this file.

Detailed Description

Fetches libraries from mpe_tables, creates extended values for alert_ds, and marks "*ALL*" as the forced (default) value.

Available macro variables:

  • DC_LIBREF - The DC control library
  • LIBDS - The library.dataset being filtered
  • VARIABLE_NM - The column being filtered

Service Outputs

Output should be a single table called "work.dynamic_values" in the format below. display_value should always be character, raw_value is unformatted character/numeric.

DYNAMIC_VALUES

The RAW_VALUE column may be charactor or numeric. If DISPLAY_INDEX is not provided, it is added automatically.

DISPLAY_INDEX:best. DISPLAY_VALUE:$ RAW_VALUE
1 $77.43 77.43
2 $88.43 88.43
DYNAMIC_EXTENDED_VALUES

This table is optional. If provided, it will map the DISPLAY_INDEX from the DYNAMIC_VALUES table to additional column/value pairs, that will be used to populate dropdowns for other cells in the same row.

Should be used sparingly! The use of large tables here can slow down the browser.

The FORCED_VALUE column can be used to force an extended value to be selected by default when a particular value is chosen.

|DISPLAY_INDEX:best.|EXTRA_COL_NAME:$32.|DISPLAY_VALUE:$|DISPLAY_TYPE:$1.|RAW_VALUE_NUM|RAW_VALUE_CHAR:$5000|FORCED_VALUE| |—|—|—|—| |1|DISCOUNT_RT|"50%"|N|0.5||.| |1|DISCOUNT_RT|"40%"|N|0.4||0| |1|DISCOUNT_RT|"30%"|N|0.3||1| |1|CURRENCY_SYMBOL|"GBP"|C||"GBP"|.| |1|CURRENCY_SYMBOL|"RSD"|C||"RSD"|.| |2|DISCOUNT_RT|"50%"|N|0.5||.| |2|DISCOUNT_RT|"40%"|N|0.4||1| |2|CURRENCY_SYMBOL|"EUR"|C||"EUR"|.| |2|CURRENCY_SYMBOL|"HKD"|C||"HKD"|1|

SAS Macros

Definition in file mpe_alerts.alert_lib.sas.