getdynamiccolvals.sas File Reference

Provide dynamic list of values according to a SAS program or service. More...

Go to the source code of this file.

Detailed Description

Configuration is made in the MPE_VALIDATIONS table, the dropdown can be either a SOFTSELECT_HOOK or HARDSELECT_HOOK.

Results are sent in ARRAY format for efficiency.

Service Inputs

SASCONTROLTABLE

LIBDS:$41.	VARIABLE_NM:$32.
DC258467.MPE_SECURITY	SAS_GROUP

SOURCE_ROW

This contains the raw values from the source table.

Service Outputs

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

• dc_assignlib.sas
• dc_getservicecode.sas
• mf_nobs.sas
• mp_abort.sas
• mp_include.sas
• mp_validatecol.sas
• mf_getapploc.sas

Version

9.3

Author

4GL Apps Ltd

Copyright

4GL Apps Ltd. This code may only be used within Data Controller and may not be re-distributed or re-sold without the express permission of 4GL Apps Ltd.

Definition in file getdynamiccolvals.sas.