tables_all.sas File Reference

Generic validator for tables in a library. More...

Go to the source code of this file.

Detailed Description

The input table is simply one row from the target table in table called "work.source_row".

Available macro variables:

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

Service Outputs

The values provided below are generic samples - we encourage you to replace these with realistic values in your own deployments.

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.

|DISPLAY_INDEX:best.|EXTRA_COL_NAME:$32.|DISPLAY_VALUE:$|DISPLAY_TYPE:$1.|RAW_VALUE_NUM|RAW_VALUE_CHAR:$5000| |—|—|—| |1|DISCOUNT_RT|"50%"|N|0.5|| |1|DISCOUNT_RT|"40%"|N|0.4|| |1|DISCOUNT_RT|"30%"|N|0.3|| |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|| |2|CURRENCY_SYMBOL|"EUR"|C||"EUR"| |2|CURRENCY_SYMBOL|"HKD"|C||"HKD"|

SAS Macros

Definition in file tables_all.sas.