mpe_tables.dsn.sas File Reference

fetch extended values for DSN More...

Go to the source code of this file.

Detailed Description

Fetches datasets in a library, and ALSO fetches a list of numeric vars for each dataset for use in adjacent columns (such as VAR_PROCESSED, TX_TO etc).

Available macro variables:

  • MPELIB - 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_tables.dsn.sas.