libraries_all.sas
Go to the documentation of this file.
1 /**
2  @file
3  @brief Generic validator for libraries
4  @details The input table is simply one row from the target table in table
5  called "work.source_row".
6 
7  Available macro variables:
8  @li MPELIB - The DC control library
9  @li LIBDS - The library.dataset being filtered
10  @li VARIABLE_NM - The column being filtered
11 
12 
13  <h4> Service Outputs </h4>
14  The values provided below are generic samples - we encourage you to replace
15  these with realistic values in your own deployments.
16 
17  <h5>DYNAMIC_VALUES</h5>
18  The RAW_VALUE column may be charactor or numeric. If DISPLAY_INDEX is not
19  provided, it is added automatically.
20 
21  |DISPLAY_INDEX:best.|DISPLAY_VALUE:$|RAW_VALUE|
22  |---|---|---|
23  |1|$77.43|77.43|
24  |2|$88.43|88.43|
25 
26  <h5>DYNAMIC_EXTENDED_VALUES</h5>
27  This table is optional. If provided, it will map the DISPLAY_INDEX from the
28  DYNAMIC_VALUES table to additional column/value pairs, that will be used to
29  populate dropdowns for _other_ cells in the _same_ row.
30 
31  Should be used sparingly! The use of large tables here can slow down the
32  browser.
33 
34  |DISPLAY_INDEX:best.|EXTRA_COL_NAME:$32.|DISPLAY_VALUE:$|DISPLAY_TYPE:$1.|RAW_VALUE_NUM|RAW_VALUE_CHAR:$5000|
35  |---|---|---|
36  |1|DISCOUNT_RT|"50%"|N|0.5||
37  |1|DISCOUNT_RT|"40%"|N|0.4||
38  |1|DISCOUNT_RT|"30%"|N|0.3||
39  |1|CURRENCY_SYMBOL|"GBP"|C||"GBP"|
40  |1|CURRENCY_SYMBOL|"RSD"|C||"RSD"|
41  |2|DISCOUNT_RT|"50%"|N|0.5||
42  |2|DISCOUNT_RT|"40%"|N|0.4||
43  |2|CURRENCY_SYMBOL|"EUR"|C||"EUR"|
44  |2|CURRENCY_SYMBOL|"HKD"|C||"HKD"|
45 
46  <h4> SAS Macros </h4>
47  @li dc_getlibs.sas
48 
49 
50 **/
51 
52 /**
53  * get full list of libraries
54  */
55 %dc_getlibs(outds=work.mm_getLibs)
56 
57 proc sql;
58 create table work.DYNAMIC_VALUES as
59  select distinct libraryname as display_value,
60  upcase(libraryref) as raw_value
61  from work.mm_getLibs
62  order by 1;
63 
64