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