Loading...
Searching...
No Matches
mpe_makedata.sas
Go to the documentation of this file.
1/**
2 @file
3 @brief Populates the Data Controller tables with sample data
4 @details
5
6 Usage:
7
8 %mpe_makedata(lib=DC869651
9 ,mpeadmins=SASAdministrators
10 ,path=/opt/data/dc/VIYA8698
11 )
12
13 <h4> SAS Macros </h4>
14 @li mf_increment.sas
15
16 @version 9.2
17 @author 4GL Apps Ltd
18 @copyright 4GL Apps Ltd - this is a licensed product and NOT FOR RESALE
19 OR DISTRIBUTION.
20**/
21
22%macro mpe_makedata(lib=,mpeadmins=,path=);
23%if &syscc ne 0 %then %do;
24 %put syscc=&syscc exiting &sysmacroname;
25 %return;
26%end;
27
28proc sql;
29insert into &lib..mpe_column_level_security set
30 tx_from=0
31 ,tx_to='31DEC9999:23:59:59'dt
32 ,CLS_SCOPE='EDIT'
33 ,CLS_GROUP='AllUsers'
34 ,CLS_LIBREF="&lib"
35 ,CLS_TABLE='MPE_LOCKANYTABLE'
36 ,CLS_VARIABLE_NM='LOCK_STATUS_CD'
37 ,CLS_ACTIVE=1
38 ,CLS_HIDE=0;
39
40insert into &lib..mpe_config set
41 tx_from=0
42 ,tx_to='31DEC9999:23:59:59'dt
43 ,var_scope="DC"
44 ,var_name="DC_EMAIL_ALERTS"
45 ,var_value='NO'
46 ,var_active=1
47 ,var_desc='YES or NO to enable email alerts. Note - this requires email '
48 !!'options to be preconfigured! They can be configured in the '
49 !!'settings stp if needed.';
50insert into &lib..mpe_config set
51 tx_from=0
52 ,tx_to='31DEC9999:23:59:59'dt
53 ,var_scope="DC"
54 ,var_name="DC_VIEWLIB_CHECK"
55 ,var_value='NO'
56 ,var_active=1
57 ,var_desc=
58 'Set to YES to enable library validity checking in viewLibs service.'
59 !!' Note: this can make the service very slow if there are lots of '
60 !!'external libraries. If enabled, this removes empty libraries from '
61 !!'the viewer library dropdown. To switch off, set to NO.';
62insert into &lib..mpe_config set
63 tx_from=0
64 ,tx_to='31DEC9999:23:59:59'dt
65 ,var_scope="DC"
66 ,var_name="DC_MACROS"
67 ,var_value=cats(symget('path'),"/dc_macros")
68 ,var_active=1
69 ,var_desc='Location of underlying macros - EUC feature.';
70insert into &lib..mpe_config set
71 tx_from=0
72 ,tx_to='31DEC9999:23:59:59'dt
73 ,var_scope="DC"
74 ,var_name="DC_MAXOBS_WEBEDIT"
75 ,var_value="250"
76 ,var_active=1
77 ,var_desc='This sets the maximum number of observations that can be loaded'
78 !!' into the browser for editing in the EDIT screen. A higher number'
79 !!' will require a decent browser (ie, not IE) and more memory on the'
80 !!' client side. The DC_MAXCELLS_WEBEDIT limit is applied at the same'
81 !!' time, whichever is reached first.';
82/* Why the cell limit exists, kept out of var_desc - MPE_CONFIG.VAR_DESC is
83 varchar(300), and a truncation WARNING aborts this whole build. A wide
84 table is expensive long before it is tall - 250 rows of a 1000 column
85 table is a quarter of a million cells. */
86insert into &lib..mpe_config set
87 tx_from=0
88 ,tx_to='31DEC9999:23:59:59'dt
89 ,var_scope="DC"
90 ,var_name="DC_MAXCELLS_WEBEDIT"
91 ,var_value="200000"
92 ,var_active=1
93 ,var_desc='This sets the maximum number of CELLS (rows multiplied by'
94 !!' columns) that can be loaded into the browser for editing in the EDIT'
95 !!' screen. Whichever of this and DC_MAXOBS_WEBEDIT is reached first'
96 !!' applies.';
97insert into &lib..mpe_config set
98 tx_from=0
99 ,tx_to='31DEC9999:23:59:59'dt
100 ,var_scope="DC"
101 ,var_name="DC_MAXOBS_WEBVIEW"
102 ,var_value="2000"
103 ,var_active=1
104 ,var_desc='This sets the maximum number of observations that can be'
105 !!' loaded into the browser in the VIEW screen.';
106insert into &lib..mpe_config set
107 tx_from=0
108 ,tx_to='31DEC9999:23:59:59'dt
109 ,var_scope="DC"
110 ,var_name="DC_REQUEST_LOGS"
111 ,var_value="YES"
112 ,var_active=1
113 ,var_desc='Setting to NO will prevent each request being logged to the'
114 !!' MPE_REQUESTS table Default=YES.';
115insert into &lib..mpe_config set
116 tx_from=0
117 ,tx_to='31DEC9999:23:59:59'dt
118 ,var_scope="DC"
119 ,var_name="DC_RESTRICT_VIEWER"
120 ,var_value="NO"
121 ,var_active=1
122 ,var_desc='YES will restrict the list of libraries and tables in VIEWER to'
123 !!' those explicitly set to VIEW in the MPE_SECURITY table. Default=NO.';
124insert into &lib..mpe_config set
125 tx_from=0
126 ,tx_to='31DEC9999:23:59:59'dt
127 ,var_scope="DC"
128 ,var_name="DC_RESTRICT_EDITRECORD"
129 ,var_value="NO"
130 ,var_active=1
131 ,var_desc='Setting YES will prevent the EDIT RECORD dialog appearing in the'
132 !!' EDIT screen by removing the "Edit Row" option in the right click menu'
133 !!', and the "ADD RECORD" button in the bottom left. Default=NO.';
134insert into &lib..mpe_config set
135 tx_from=0
136 ,tx_to='31DEC9999:23:59:59'dt
137 ,var_scope="DC_CATALOG"
138 ,var_name="DC_IGNORELIBS"
139 ,var_value="|MAPSSAS|MAPS|"
140 ,var_active=1
141 ,var_desc='Pipe seperated list of librefs (uppercase) to be ignored when'
142 !!' running the Data Catalog refresh process. This can enable a clean'
143 !!' run when invalid librefs are returned by the mpe_refreshlibs macro.';
144insert into &lib..mpe_config set
145 tx_from=0
146 ,tx_to='31DEC9999:23:59:59'dt
147 ,var_scope="DC"
148 ,var_name="DC_LOCALE"
149 ,var_value="SYSTEM"
150 ,var_active=1
151 ,var_desc='Set to a locale (such as en_gb or en_be) to override the system'
152 !!' value (which can be driven from the browser settings). This is '
153 !!'useful when importing ambiguous dates from CSV or Excel (eg 1/2/20 vs '
154 !!'2/1/20) as DC uses the anydtdtm informats for import. Default=SYSTEM.';
155insert into &lib..mpe_config set
156 tx_from=0
157 ,tx_to='31DEC9999:23:59:59'dt
158 ,var_scope="DCBL_REDSH"
159 ,var_name="BULKLOAD"
160 ,var_value="YES"
161 ,var_active=0
162 ,var_desc='Set to YES to enable BULKLOAD=YES in redshift';
163insert into &lib..mpe_config set
164 tx_from=0
165 ,tx_to='31DEC9999:23:59:59'dt
166 ,var_scope="DCBL_REDSH"
167 ,var_name="BL_BUCKET"
168 ,var_value="'your-aws-bucket/Exchange'"
169 ,var_active=0
170 ,var_desc='Set to the (quoted) value of the AWS bucket to'
171 !!' use for s3 uploads in redshift';
172insert into &lib..mpe_config set
173 tx_from=0
174 ,tx_to='31DEC9999:23:59:59'dt
175 ,var_scope="DCBL_REDSH"
176 ,var_name="BL_AWS_CREDENTIALS_FILE"
177 ,var_value="'/path/to/your/aws/s3/.credentials'"
178 ,var_active=0
179 ,var_desc='Set to the (quoted) value of the AWS creds file';
180insert into &lib..mpe_config set
181 tx_from=0
182 ,tx_to='31DEC9999:23:59:59'dt
183 ,var_scope="DCBL_REDSH"
184 ,var_name="BL_REGION"
185 ,var_value="'eu-west-1'"
186 ,var_active=0
187 ,var_desc='Set to the (quoted) AWS region in use';
188insert into &lib..mpe_config set
189 tx_from=0
190 ,tx_to='31DEC9999:23:59:59'dt
191 ,var_scope="DCBL_REDSH"
192 ,var_name="BL_COMPRESS"
193 ,var_value="YES"
194 ,var_active=0
195 ,var_desc='Set to YES to perform compression ahead of the COPY command';
196insert into &lib..mpe_config set
197 tx_from=0
198 ,tx_to='31DEC9999:23:59:59'dt
199 ,var_scope="DCBL_REDSH"
200 ,var_name="BL_USE_SSL"
201 ,var_value="YES"
202 ,var_active=0
203 ,var_desc='Set to YES to use SSL encryption';
204insert into &lib..mpe_config set
205 tx_from=0
206 ,tx_to='31DEC9999:23:59:59'dt
207 ,var_scope="DC_REVIEW"
208 ,var_name="HISTORY_ROWS"
209 ,var_value='100'
210 ,var_active=1
211 ,var_desc='Number of rows (or additional rows) to return in the HISTORY '
212 !!'page';
213insert into &lib..mpe_config set
214 tx_from=0
215 ,tx_to='31DEC9999:23:59:59'dt
216 ,var_scope="DC"
217 ,var_name="DC_LICENCE_KEY"
218 ,var_value=' '
219 ,var_active=1
220 ,var_desc='Licence Key';
221insert into &lib..mpe_config set
222 tx_from=0
223 ,tx_to='31DEC9999:23:59:59'dt
224 ,var_scope="DC"
225 ,var_name="DC_ACTIVATION_KEY"
226 ,var_value=' '
227 ,var_active=1
228 ,var_desc='Activation Key';
229insert into &lib..mpe_config set
230 tx_from=0
231 ,tx_to='31DEC9999:23:59:59'dt
232 ,var_scope="DC_EMAIL"
233 ,var_name="SUBMITTED_TEMPLATE"
234 ,var_value='Dear user,'!!'0A'x!!'Please be advised that a change to table'
235 !!' &alert_lib..&alert_ds has been proposed by &from_user on the '
236 !!'&syshostname SAS server.'!!'0A'x!!'Reason provided: '
237 !!'%superq(SUBMITTED_TXT)'
238 !!'0A'x!!'This is an automated email by Data Controller for SAS. For '
239 !!'documentation, please visit https://docs.datacontroller.io'
240 ,var_active=1
241 ,var_desc='Template email, sent after submitting a change';
242insert into &lib..mpe_config set
243 tx_from=0
244 ,tx_to='31DEC9999:23:59:59'dt
245 ,var_scope="DC_EMAIL"
246 ,var_name="APPROVED_TEMPLATE"
247 ,var_value='Dear user,'!!'0A'x!!'Please be advised that a change to table'
248 !!' &alert_lib..&alert_ds has been approved by &from_user on the '
249 !!'&syshostname SAS server.'!!'0A'x!!'This is an automated email by Data'
250 !!' Controller for SAS. For documentation, please visit '
251 !!'https://docs.datacontroller.io'
252 ,var_active=1
253 ,var_desc='Template email, sent after approving a change';
254insert into &lib..mpe_config set
255 tx_from=0
256 ,tx_to='31DEC9999:23:59:59'dt
257 ,var_scope="DC_EMAIL"
258 ,var_name="REJECTED_TEMPLATE"
259 ,var_value='Dear user,'!!'0A'x!!'Please be advised that a change to table'
260 !!' &alert_lib..&alert_ds has been rejected by &from_user on the '
261 !!'&syshostname SAS server.'!!'0A'x!!'Reason provided: '
262 !!'%superq(REVIEW_REASON_TXT)'
263 !!'0A'x!!'This is an automated email by Data Controller for SAS. For '
264 !!'documentation, please visit https://docs.datacontroller.io'
265 ,var_active=1
266 ,var_desc='Template email, sent after rejecting a change';
267
268
269insert into &lib..mpe_datadictionary set
270 tx_from=0
271 ,DD_TYPE='LIBRARY'
272 ,DD_SOURCE="&lib"
273 ,DD_SHORTDESC="Data Controller Control Tables"
274 ,DD_LONGDESC="# The Data Controller Library"
275 ,DD_OWNER="&sysuserid"
276 ,DD_RESPONSIBLE="&sysuserid"
277 ,DD_SENSITIVITY="Low"
278 ,tx_to='31DEC5999:23:59:59'dt;
279insert into &lib..mpe_datadictionary set
280 tx_from=0
281 ,DD_TYPE='TABLE'
282 ,DD_SOURCE="&lib..MPE_TABLES"
283 ,DD_SHORTDESC="Configuration of new tables for Data Controller"
284 ,DD_LONGDESC="# MPE_TABLES - adding new tabels to Data Controller"
285 ,DD_OWNER="&sysuserid"
286 ,DD_RESPONSIBLE="&sysuserid"
287 ,DD_SENSITIVITY="Low"
288 ,tx_to='31DEC5999:23:59:59'dt;
289insert into &lib..mpe_datadictionary set
290 tx_from=0
291 ,DD_TYPE='COLUMN'
292 ,DD_SOURCE="&lib..MPE_TABLES.DSN"
293 ,DD_SHORTDESC="Dataset Name to be edited"
294 ,DD_LONGDESC="_DSN_ - must be UPCASE"
295 ,DD_OWNER="&sysuserid"
296 ,DD_RESPONSIBLE="&sysuserid"
297 ,DD_SENSITIVITY="Low"
298 ,tx_to='31DEC5999:23:59:59'dt;
299insert into &lib..mpe_datadictionary set
300 tx_from=0
301 ,DD_TYPE='DIRECTORY'
302 ,DD_SOURCE="/some/directory"
303 ,DD_SHORTDESC="Directory for some purpose"
304 ,DD_LONGDESC="This directory is great. It's great directory.
305 It trumps all other directories."
306 ,DD_OWNER="&sysuserid"
307 ,DD_RESPONSIBLE="&sysuserid"
308 ,DD_SENSITIVITY="Low"
309 ,tx_to='31DEC5999:23:59:59'dt;
310insert into &lib..mpe_datadictionary set
311 tx_from=0
312 ,DD_TYPE='TABLE'
313 ,DD_SOURCE="&lib"
314 ,DD_SHORTDESC="Transaction table for capturing Data Controller users"
315 ,DD_LONGDESC="After a user accepts the Data Controller EULA they are "
316 !!"registered as a user in this table."
317 ,DD_OWNER="&sysuserid"
318 ,DD_RESPONSIBLE="&sysuserid"
319 ,DD_SENSITIVITY="Low"
320 ,tx_to='31DEC5999:23:59:59'dt;
321insert into &lib..mpe_datadictionary set
322 tx_from=0
323 ,DD_TYPE='COLUMN'
324 ,DD_SOURCE="&lib..MPE_CONFIG.VAR_ACTIVE"
325 ,DD_SHORTDESC="Set to 1 to make an option active"
326 ,DD_LONGDESC="This value is used as a filter by data controller whenever "
327 !!"querying for option settings."
328 ,DD_OWNER="&sysuserid"
329 ,DD_RESPONSIBLE="&sysuserid"
330 ,DD_SENSITIVITY="Low"
331 ,tx_to='31DEC5999:23:59:59'dt;
332
333/**
334 * mpe_xlmap_info
335 */
336insert into &lib..mpe_xlmap_info set
337 tx_from=0
338 ,tx_to='31DEC5999:23:59:59'dt
339 ,xlmap_id='BASEL-KM1'
340 ,xlmap_description='Basel 3 Key Metrics report'
341 ,XLMAP_TARGETLIBDS="&lib..MPE_XLMAP_DATA";
342
343/**
344 * mpe_xlmap_rules
345 */
346insert into &lib..mpe_xlmap_rules set
347 tx_from=0
348 ,tx_to='31DEC5999:23:59:59'dt
349 ,xlmap_id='BASEL-KM1'
350 ,xlmap_range_id='KM1:a'
351 ,xlmap_sheet='KM1'
352 ,xlmap_start='MATCH 4 R[2]C[0]:a';
353insert into &lib..mpe_xlmap_rules set
354 tx_from=0
355 ,tx_to='31DEC5999:23:59:59'dt
356 ,xlmap_id='BASEL-KM1'
357 ,xlmap_range_id='KM1:b'
358 ,xlmap_sheet='KM1'
359 ,xlmap_start='MATCH 4 R[2]C[0]:b';
360insert into &lib..mpe_xlmap_rules set
361 tx_from=0
362 ,tx_to='31DEC5999:23:59:59'dt
363 ,xlmap_id='BASEL-KM1'
364 ,xlmap_range_id='KM1:c'
365 ,xlmap_sheet='KM1'
366 ,xlmap_start='MATCH 4 R[2]C[0]:c';
367insert into &lib..mpe_xlmap_rules set
368 tx_from=0
369 ,tx_to='31DEC5999:23:59:59'dt
370 ,xlmap_id='BASEL-KM1'
371 ,xlmap_range_id='KM1:d'
372 ,xlmap_sheet='KM1'
373 ,xlmap_start='MATCH 4 R[2]C[0]:d';
374insert into &lib..mpe_xlmap_rules set
375 tx_from=0
376 ,tx_to='31DEC5999:23:59:59'dt
377 ,xlmap_id='BASEL-KM1'
378 ,xlmap_range_id='KM1:e'
379 ,xlmap_sheet='KM1'
380 ,xlmap_start='MATCH 4 R[2]C[0]:e';
381insert into &lib..mpe_xlmap_rules set
382 tx_from=0
383 ,tx_to='31DEC5999:23:59:59'dt
384 ,xlmap_id='BASEL-KM1'
385 ,xlmap_range_id='KM1:f'
386 ,xlmap_sheet='KM1'
387 ,xlmap_start='MATCH 4 R[2]C[0]:f';
388insert into &lib..mpe_xlmap_rules set
389 tx_from=0
390 ,tx_to='31DEC5999:23:59:59'dt
391 ,xlmap_id='BASEL-KM1'
392 ,xlmap_range_id='KM1:1/a'
393 ,xlmap_sheet='KM1'
394 ,xlmap_start='MATCH C R[0]C[1]:Common Equity Tier 1 (CET1)';
395insert into &lib..mpe_xlmap_rules set
396 tx_from=0
397 ,tx_to='31DEC5999:23:59:59'dt
398 ,xlmap_id='BASEL-KM1'
399 ,xlmap_range_id='KM1:1/b'
400 ,xlmap_sheet='KM1'
401 ,xlmap_start='MATCH C R[0]C[2]:Common Equity Tier 1 (CET1)';
402 insert into &lib..mpe_xlmap_rules set
403 tx_from=0
404 ,tx_to='31DEC5999:23:59:59'dt
405 ,xlmap_id='BASEL-KM1'
406 ,xlmap_range_id='KM1:1/c'
407 ,xlmap_sheet='KM1'
408 ,xlmap_start='MATCH C R[0]C[3]:Common Equity Tier 1 (CET1)';
409 insert into &lib..mpe_xlmap_rules set
410 tx_from=0
411 ,tx_to='31DEC5999:23:59:59'dt
412 ,xlmap_id='BASEL-KM1'
413 ,xlmap_range_id='KM1:1/d'
414 ,xlmap_sheet='KM1'
415 ,xlmap_start='MATCH C R[0]C[4]:Common Equity Tier 1 (CET1)';
416 insert into &lib..mpe_xlmap_rules set
417 tx_from=0
418 ,tx_to='31DEC5999:23:59:59'dt
419 ,xlmap_id='BASEL-KM1'
420 ,xlmap_range_id='KM1:1/e'
421 ,xlmap_sheet='KM1'
422 ,xlmap_start='MATCH C R[0]C[5]:Common Equity Tier 1 (CET1)';
423insert into &lib..mpe_xlmap_rules set
424 tx_from=0
425 ,tx_to='31DEC5999:23:59:59'dt
426 ,xlmap_id='BASEL-KM1'
427 ,xlmap_range_id='KM1:1/f'
428 ,xlmap_sheet='KM1'
429 ,xlmap_start='MATCH C R[0]C[6]:Common Equity Tier 1 (CET1)';
430insert into &lib..mpe_xlmap_rules set
431 tx_from=0
432 ,tx_to='31DEC5999:23:59:59'dt
433 ,xlmap_id='BASEL-KM1'
434 ,xlmap_range_id='KM1:1a/e'
435 ,xlmap_sheet='KM1'
436 ,xlmap_start='MATCH C R[1]C[5]:Common Equity Tier 1 (CET1)';
437insert into &lib..mpe_xlmap_rules set
438 tx_from=0
439 ,tx_to='31DEC5999:23:59:59'dt
440 ,xlmap_id='BASEL-KM1'
441 ,xlmap_range_id='KM1:1a/f'
442 ,xlmap_sheet='KM1'
443 ,xlmap_start='MATCH C R[1]C[6]:Common Equity Tier 1 (CET1)';
444insert into &lib..mpe_xlmap_rules set
445 tx_from=0
446 ,tx_to='31DEC5999:23:59:59'dt
447 ,xlmap_id='BASEL-KM1'
448 ,xlmap_range_id='KM1:2/a'
449 ,xlmap_sheet='KM1'
450 ,xlmap_start='ABSOLUTE D10';
451insert into &lib..mpe_xlmap_rules set
452 tx_from=0
453 ,tx_to='31DEC5999:23:59:59'dt
454 ,xlmap_id='BASEL-KM1'
455 ,xlmap_range_id='KM1:2/b'
456 ,xlmap_sheet='/3'
457 ,xlmap_start='ABSOLUTE E10';
458insert into &lib..mpe_xlmap_rules set
459 tx_from=0
460 ,tx_to='31DEC5999:23:59:59'dt
461 ,xlmap_id='BASEL-KM1'
462 ,xlmap_range_id='KM1:2/c'
463 ,xlmap_sheet='/3'
464 ,xlmap_start='RELATIVE R[10]C[6]';
465insert into &lib..mpe_xlmap_rules set
466 tx_from=0
467 ,tx_to='31DEC5999:23:59:59'dt
468 ,xlmap_id='BASEL-KM1'
469 ,xlmap_range_id='KM1:2/d'
470 ,xlmap_sheet='/3'
471 ,xlmap_start='RELATIVE R[10]C[8]';
472insert into &lib..mpe_xlmap_rules set
473 tx_from=0
474 ,tx_to='31DEC5999:23:59:59'dt
475 ,xlmap_id='BASEL-KM1'
476 ,xlmap_range_id='KM1:2/e'
477 ,xlmap_sheet='/3'
478 ,xlmap_start='RELATIVE R[10]C[9]';
479insert into &lib..mpe_xlmap_rules set
480 tx_from=0
481 ,tx_to='31DEC5999:23:59:59'dt
482 ,xlmap_id='BASEL-KM1'
483 ,xlmap_range_id='KM1:2/f'
484 ,xlmap_sheet='/3'
485 ,xlmap_start='RELATIVE R[10]C[10]';
486insert into &lib..mpe_xlmap_rules set
487 tx_from=0
488 ,tx_to='31DEC5999:23:59:59'dt
489 ,xlmap_id='BASEL-KM1'
490 ,xlmap_range_id='KM1:2a'
491 ,xlmap_sheet='KM1'
492 ,xlmap_start='ABSOLUTE H11'
493 ,xlmap_finish='RELATIVE R[0]C[1]';
494insert into &lib..mpe_xlmap_rules set
495 tx_from=0
496 ,tx_to='31DEC5999:23:59:59'dt
497 ,xlmap_id='BASEL-KM1'
498 ,xlmap_range_id='KM1:3'
499 ,xlmap_sheet='KM1'
500 ,xlmap_start='RELATIVE R[12]C[4]'
501 ,xlmap_finish='ABSOLUTE I13';
502insert into &lib..mpe_xlmap_rules set
503 tx_from=0
504 ,tx_to='31DEC5999:23:59:59'dt
505 ,xlmap_id='BASEL-CR2'
506 ,xlmap_range_id='CR2-sec1'
507 ,xlmap_sheet='CR2'
508 ,xlmap_start='ABSOLUTE D8'
509 ,xlmap_finish='BLANKROW';
510insert into &lib..mpe_xlmap_rules set
511 tx_from=0
512 ,tx_to='31DEC5999:23:59:59'dt
513 ,xlmap_id='BASEL-CR2'
514 ,xlmap_range_id='CR2-sec2'
515 ,xlmap_sheet='CR2'
516 ,xlmap_start='ABSOLUTE D18'
517 ,xlmap_finish='LASTDOWN';
518insert into &lib..mpe_xlmap_rules set
519 tx_from=0
520 ,tx_to='31DEC5999:23:59:59'dt
521 ,xlmap_id='SAMPLE'
522 ,xlmap_range_id='header'
523 ,xlmap_sheet='/1'
524 ,xlmap_start='ABSOLUTE B3'
525 ,xlmap_finish='ABSOLUTE B8';
526insert into &lib..mpe_xlmap_rules set
527 tx_from=0
528 ,tx_to='31DEC5999:23:59:59'dt
529 ,xlmap_id='SAMPLE'
530 ,xlmap_range_id='data'
531 ,xlmap_sheet='/1'
532 ,xlmap_start='ABSOLUTE B13'
533 ,xlmap_finish='ABSOLUTE E16';
534
535
536
537/**
538 * MPE_GROUPS
539 */
540insert into &lib..mpe_groups set
541 tx_from=0
542 ,group_name="dc-admin"
543 ,group_desc="Custom Group for Data Controller Purposes"
544 ,user_name="allbow"
545 ,tx_to='31DEC5999:23:59:59'dt;
546insert into &lib..mpe_groups set
547 tx_from=0
548 ,group_name="dc-admin"
549 ,group_desc="Custom Group for Data Controller Purposes"
550 ,user_name="dctestuser1"
551 ,tx_to='31DEC5999:23:59:59'dt;
552insert into &lib..mpe_groups set
553 tx_from=0
554 ,group_name="dc-admin"
555 ,group_desc="Custom Group for Data Controller Purposes"
556 ,user_name="mihmed"
557 ,tx_to='31DEC5999:23:59:59'dt;
558insert into &lib..mpe_groups set
559 tx_from=0
560 ,group_name="sec-sas9-prd-ext-sasplatform-300115datacontroller"
561 ,group_desc="Custom Group for Data Controller Purposes"
562 ,user_name="DCTest"
563 ,tx_to='31DEC5999:23:59:59'dt;
564
565/**
566 * MPE_ROW_LEVEL_SECURITY
567 */
568insert into &lib..mpe_row_level_security set
569 tx_from=0
570 ,tx_to='31DEC5999:23:59:59'dt
571 ,RLS_RK=1
572 ,RLS_SCOPE='ALL'
573 ,RLS_GROUP='sec-sas9-prd-int-sasplatform-300114sasjs'
574 ,RLS_LIBREF="&lib."
575 ,RLS_TABLE="MPE_GROUPS"
576 ,RLS_GROUP_LOGIC='AND'
577 ,RLS_SUBGROUP_LOGIC='OR'
578 ,RLS_SUBGROUP_ID=0
579 ,RLS_VARIABLE_NM='GROUP_NAME'
580 ,RLS_OPERATOR_NM='NE'
581 ,RLS_RAW_VALUE="'-1'"
582 ,RLS_ACTIVE=1;
583insert into &lib..mpe_row_level_security set
584 tx_from=0
585 ,tx_to='31DEC5999:23:59:59'dt
586 ,RLS_RK=2
587 ,RLS_SCOPE='ALL'
588 ,RLS_GROUP='sec-sas9-prd-int-sasplatform-300114sasjs'
589 ,RLS_LIBREF="&lib"
590 ,RLS_TABLE="MPE_ROW_LEVEL_SECURITY"
591 ,RLS_GROUP_LOGIC='AND'
592 ,RLS_SUBGROUP_LOGIC='OR'
593 ,RLS_SUBGROUP_ID=0
594 ,RLS_VARIABLE_NM='RLS_RK'
595 ,RLS_OPERATOR_NM='>'
596 ,RLS_RAW_VALUE='0'
597 ,RLS_ACTIVE=1;
598insert into &lib..mpe_row_level_security set
599 tx_from=0
600 ,tx_to='31DEC5999:23:59:59'dt
601 ,RLS_RK=3
602 ,RLS_SCOPE='ALL'
603 ,RLS_GROUP='DC Demo Group'
604 ,RLS_LIBREF="&lib"
605 ,RLS_TABLE="MPE_SECURITY"
606 ,RLS_GROUP_LOGIC='AND'
607 ,RLS_SUBGROUP_LOGIC='OR'
608 ,RLS_SUBGROUP_ID=0
609 ,RLS_VARIABLE_NM='ACCESS_LEVEL'
610 ,RLS_OPERATOR_NM='NE'
611 ,RLS_RAW_VALUE="'N/A'"
612 ,RLS_ACTIVE=1;
613
614
615/**
616 * MPE_SECURITY
617 */
618insert into &lib..mpe_security set
619 tx_from=0
620 ,libref="*ALL*"
621 ,dsn="*ALL*"
622 ,access_level="APPROVE"
623 ,sas_group="sec-sas9-prd-int-sasplatform-300114sasjs"
624 ,tx_to='31DEC5999:23:59:59'dt;
625insert into &lib..mpe_security set
626 tx_from=0
627 ,libref="*ALL*"
628 ,dsn="*ALL*"
629 ,access_level="EDIT"
630 ,sas_group="sec-sas9-prd-int-sasplatform-300114sasjs"
631 ,tx_to='31DEC5999:23:59:59'dt;
632insert into &lib..mpe_security set
633 tx_from=0
634 ,libref="*ALL*"
635 ,dsn="*ALL*"
636 ,access_level="APPROVE"
637 ,sas_group="sec-sas9-prd-ext-sasplatform-300114sasjs"
638 ,tx_to='31DEC5999:23:59:59'dt;
639insert into &lib..mpe_security set
640 tx_from=0
641 ,libref="*ALL*"
642 ,dsn="*ALL*"
643 ,access_level="EDIT"
644 ,sas_group="sec-sas9-prd-ext-sasplatform-300114sasjs"
645 ,tx_to='31DEC5999:23:59:59'dt;
646insert into &lib..mpe_security set
647 tx_from=0
648 ,libref="*ALL*"
649 ,dsn="*ALL*"
650 ,access_level="EDIT"
651 ,sas_group="dc-admin"
652 ,tx_to='31DEC5999:23:59:59'dt;
653insert into &lib..mpe_security set
654 tx_from=0
655 ,libref="*ALL*"
656 ,dsn="*ALL*"
657 ,access_level="APPROVE"
658 ,sas_group="dc-admin"
659 ,tx_to='31DEC5999:23:59:59'dt;
660
661
662 /* mpe_selectbox */
663 %let rk=1;
664 insert into &lib..mpe_selectbox set
665 selectbox_rk=&rk
666 ,ver_from_dttm=0
667 ,select_lib="&lib"
668 ,select_ds="MPE_LOCKANYTABLE"
669 ,base_column="LOCK_STATUS_CD"
670 ,selectbox_value='LOCKED'
671 ,selectbox_order=1
672 ,ver_to_dttm='31DEC5999:23:59:59'dt;
673 insert into &lib..mpe_selectbox set
674 selectbox_rk=%mf_increment(rk)
675 ,ver_from_dttm=0
676 ,select_lib="&lib"
677 ,select_ds="MPE_LOCKANYTABLE"
678 ,base_column="LOCK_STATUS_CD"
679 ,selectbox_value='UNLOCKED'
680 ,selectbox_order=2
681 ,ver_to_dttm='31DEC5999:23:59:59'dt;
682 insert into &lib..mpe_selectbox set
683 selectbox_rk=%mf_increment(rk)
684 ,ver_from_dttm=0
685 ,select_lib="&lib"
686 ,select_ds="MPE_SECURITY"
687 ,base_column="ACCESS_LEVEL"
688 ,selectbox_value='EDIT'
689 ,selectbox_order=0
690 ,ver_to_dttm='31DEC5999:23:59:59'dt;
691 insert into &lib..mpe_selectbox set
692 selectbox_rk=%mf_increment(rk)
693 ,ver_from_dttm=0
694 ,select_lib="&lib"
695 ,select_ds="MPE_SECURITY"
696 ,base_column="ACCESS_LEVEL"
697 ,selectbox_value='APPROVE'
698 ,selectbox_order=1
699 ,ver_to_dttm='31DEC5999:23:59:59'dt;
700 insert into &lib..mpe_selectbox set
701 selectbox_rk=%mf_increment(rk)
702 ,ver_from_dttm=0
703 ,select_lib="&lib"
704 ,select_ds="MPE_SECURITY"
705 ,base_column="ACCESS_LEVEL"
706 ,selectbox_value='VIEW'
707 ,selectbox_order=2
708 ,ver_to_dttm='31DEC5999:23:59:59'dt;
709 insert into &lib..mpe_selectbox set
710 selectbox_rk=%mf_increment(rk)
711 ,ver_from_dttm=0
712 ,select_lib="&lib"
713 ,select_ds="MPE_SECURITY"
714 ,base_column="ACCESS_LEVEL"
715 ,selectbox_value='SIGNOFF'
716 ,selectbox_order=3
717 ,ver_to_dttm='31DEC5999:23:59:59'dt;
718 insert into &lib..mpe_selectbox set
719 selectbox_rk=%mf_increment(rk)
720 ,ver_from_dttm=0
721 ,select_lib="&lib"
722 ,select_ds="MPE_TABLES"
723 ,base_column="LOADTYPE"
724 ,selectbox_value='UPDATE'
725 ,selectbox_order=1
726 ,ver_to_dttm='31DEC5999:23:59:59'dt;
727 insert into &lib..mpe_selectbox set
728 selectbox_rk=%mf_increment(rk)
729 ,ver_from_dttm=0
730 ,select_lib="&lib"
731 ,select_ds="MPE_TABLES"
732 ,base_column="LOADTYPE"
733 ,selectbox_value='REPLACE'
734 ,selectbox_order=2
735 ,ver_to_dttm='31DEC5999:23:59:59'dt;
736 insert into &lib..mpe_selectbox set
737 selectbox_rk=%mf_increment(rk)
738 ,ver_from_dttm=0
739 ,select_lib="&lib"
740 ,select_ds="MPE_TABLES"
741 ,base_column="LOADTYPE"
742 ,selectbox_value='TXTEMPORAL'
743 ,selectbox_order=3
744 ,ver_to_dttm='31DEC5999:23:59:59'dt;
745 insert into &lib..mpe_selectbox set
746 selectbox_rk=%mf_increment(rk)
747 ,ver_from_dttm=0
748 ,select_lib="&lib"
749 ,select_ds="MPE_TABLES"
750 ,base_column="LOADTYPE"
751 ,selectbox_value='BITEMPORAL'
752 ,selectbox_order=4
753 ,ver_to_dttm='31DEC5999:23:59:59'dt;
754insert into &lib..mpe_selectbox set
755 selectbox_rk=%mf_increment(rk)
756 ,ver_from_dttm=0
757 ,select_lib="&lib"
758 ,select_ds="MPE_TABLES"
759 ,base_column="LOADTYPE"
760 ,selectbox_value='FORMAT_CAT'
761 ,selectbox_order=5
762 ,ver_to_dttm='31DEC5999:23:59:59'dt;
763 insert into &lib..mpe_selectbox set
764 selectbox_rk=%mf_increment(rk)
765 ,ver_from_dttm=0
766 ,select_lib="&lib"
767 ,select_ds="MPE_ALERTS"
768 ,base_column="ALERT_EVENT"
769 ,selectbox_value='*ALL*'
770 ,selectbox_order=1
771 ,ver_to_dttm='31DEC5999:23:59:59'dt;
772 insert into &lib..mpe_selectbox set
773 selectbox_rk=%mf_increment(rk)
774 ,ver_from_dttm=0
775 ,select_lib="&lib"
776 ,select_ds="MPE_ALERTS"
777 ,base_column="ALERT_EVENT"
778 ,selectbox_value='SUBMITTED'
779 ,selectbox_order=2
780 ,ver_to_dttm='31DEC5999:23:59:59'dt;
781 insert into &lib..mpe_selectbox set
782 selectbox_rk=%mf_increment(rk)
783 ,ver_from_dttm=0
784 ,select_lib="&lib"
785 ,select_ds="MPE_ALERTS"
786 ,base_column="ALERT_EVENT"
787 ,selectbox_value='APPROVED'
788 ,selectbox_order=3
789 ,ver_to_dttm='31DEC5999:23:59:59'dt;
790 insert into &lib..mpe_selectbox set
791 selectbox_rk=%mf_increment(rk)
792 ,ver_from_dttm=0
793 ,select_lib="&lib"
794 ,select_ds="MPE_ALERTS"
795 ,base_column="ALERT_EVENT"
796 ,selectbox_value='REJECTED'
797 ,selectbox_order=4
798 ,ver_to_dttm='31DEC5999:23:59:59'dt;
799 insert into &lib..mpe_selectbox set
800 selectbox_rk=%mf_increment(rk)
801 ,ver_from_dttm=0
802 ,select_lib="&lib"
803 ,select_ds="MPE_X_TEST"
804 ,base_column="SOME_DROPDOWN"
805 ,selectbox_value='Option 1'
806 ,selectbox_order=1
807 ,ver_to_dttm='31DEC5999:23:59:59'dt;
808 insert into &lib..mpe_selectbox set
809 selectbox_rk=%mf_increment(rk)
810 ,ver_from_dttm=0
811 ,select_lib="&lib"
812 ,select_ds="MPE_X_TEST"
813 ,base_column="SOME_DROPDOWN"
814 ,selectbox_value='Option 2'
815 ,selectbox_order=2
816 ,ver_to_dttm='31DEC5999:23:59:59'dt;
817 insert into &lib..mpe_selectbox set
818 selectbox_rk=%mf_increment(rk)
819 ,ver_from_dttm=0
820 ,select_lib="&lib"
821 ,select_ds="MPE_X_TEST"
822 ,base_column="SOME_DROPDOWN"
823 ,selectbox_value='Option 3'
824 ,selectbox_order=2
825 ,ver_to_dttm='31DEC5999:23:59:59'dt;
826 insert into &lib..mpe_selectbox set
827 selectbox_rk=%mf_increment(rk)
828 ,ver_from_dttm=0
829 ,select_lib="&lib"
830 ,select_ds="MPE_X_TEST"
831 ,base_column="SOME_DROPDOWN"
832 ,selectbox_value="This is a long option. This option is very long. "
833 !!"It is optional, though."
834 ,selectbox_order=3
835 ,ver_to_dttm='31DEC5999:23:59:59'dt;
836 insert into &lib..mpe_selectbox set
837 selectbox_rk=%mf_increment(rk)
838 ,ver_from_dttm=0
839 ,select_lib="&lib"
840 ,select_ds="MPE_VALIDATIONS"
841 ,base_column="RULE_TYPE"
842 ,selectbox_value="CASE"
843 ,selectbox_order=1
844 ,ver_to_dttm='31DEC5999:23:59:59'dt;
845 insert into &lib..mpe_selectbox set
846 selectbox_rk=%mf_increment(rk)
847 ,ver_from_dttm=0
848 ,select_lib="&lib"
849 ,select_ds="MPE_VALIDATIONS"
850 ,base_column="RULE_TYPE"
851 ,selectbox_value="HARDSELECT"
852 ,selectbox_order=2
853 ,ver_to_dttm='31DEC5999:23:59:59'dt;
854 insert into &lib..mpe_selectbox set
855 selectbox_rk=%mf_increment(rk)
856 ,ver_from_dttm=0
857 ,select_lib="&lib"
858 ,select_ds="MPE_VALIDATIONS"
859 ,base_column="RULE_TYPE"
860 ,selectbox_value="HARDSELECT_HOOK"
861 ,selectbox_order=3
862 ,ver_to_dttm='31DEC5999:23:59:59'dt;
863 insert into &lib..mpe_selectbox set
864 selectbox_rk=%mf_increment(rk)
865 ,ver_from_dttm=0
866 ,select_lib="&lib"
867 ,select_ds="MPE_VALIDATIONS"
868 ,base_column="RULE_TYPE"
869 ,selectbox_value="HIDDEN"
870 ,selectbox_order=4
871 ,ver_to_dttm='31DEC5999:23:59:59'dt;
872 insert into &lib..mpe_selectbox set
873 selectbox_rk=%mf_increment(rk)
874 ,ver_from_dttm=0
875 ,select_lib="&lib"
876 ,select_ds="MPE_VALIDATIONS"
877 ,base_column="RULE_TYPE"
878 ,selectbox_value="MAXVAL"
879 ,selectbox_order=5
880 ,ver_to_dttm='31DEC5999:23:59:59'dt;
881 insert into &lib..mpe_selectbox set
882 selectbox_rk=%mf_increment(rk)
883 ,ver_from_dttm=0
884 ,select_lib="&lib"
885 ,select_ds="MPE_VALIDATIONS"
886 ,base_column="RULE_TYPE"
887 ,selectbox_value="MINVAL"
888 ,selectbox_order=6
889 ,ver_to_dttm='31DEC5999:23:59:59'dt;
890 insert into &lib..mpe_selectbox set
891 selectbox_rk=%mf_increment(rk)
892 ,ver_from_dttm=0
893 ,select_lib="&lib"
894 ,select_ds="MPE_VALIDATIONS"
895 ,base_column="RULE_TYPE"
896 ,selectbox_value="NOTNULL"
897 ,selectbox_order=7
898 ,ver_to_dttm='31DEC5999:23:59:59'dt;
899 insert into &lib..mpe_selectbox set
900 selectbox_rk=%mf_increment(rk)
901 ,ver_from_dttm=0
902 ,select_lib="&lib"
903 ,select_ds="MPE_VALIDATIONS"
904 ,base_column="RULE_TYPE"
905 ,selectbox_value="NUMBER_FORMAT"
906 ,selectbox_order=8
907 ,ver_to_dttm='31DEC5999:23:59:59'dt;
908 insert into &lib..mpe_selectbox set
909 selectbox_rk=%mf_increment(rk)
910 ,ver_from_dttm=0
911 ,select_lib="&lib"
912 ,select_ds="MPE_VALIDATIONS"
913 ,base_column="RULE_TYPE"
914 ,selectbox_value="READONLY"
915 ,selectbox_order=9
916 ,ver_to_dttm='31DEC5999:23:59:59'dt;
917 insert into &lib..mpe_selectbox set
918 selectbox_rk=%mf_increment(rk)
919 ,ver_from_dttm=0
920 ,select_lib="&lib"
921 ,select_ds="MPE_VALIDATIONS"
922 ,base_column="RULE_TYPE"
923 ,selectbox_value="ROUND"
924 ,selectbox_order=10
925 ,ver_to_dttm='31DEC5999:23:59:59'dt;
926 insert into &lib..mpe_selectbox set
927 selectbox_rk=%mf_increment(rk)
928 ,ver_from_dttm=0
929 ,select_lib="&lib"
930 ,select_ds="MPE_VALIDATIONS"
931 ,base_column="RULE_TYPE"
932 ,selectbox_value="SOFTSELECT"
933 ,selectbox_order=11
934 ,ver_to_dttm='31DEC5999:23:59:59'dt;
935 insert into &lib..mpe_selectbox set
936 selectbox_rk=%mf_increment(rk)
937 ,ver_from_dttm=0
938 ,select_lib="&lib"
939 ,select_ds="MPE_VALIDATIONS"
940 ,base_column="RULE_TYPE"
941 ,selectbox_value="SOFTSELECT_HOOK"
942 ,selectbox_order=12
943 ,ver_to_dttm='31DEC5999:23:59:59'dt;
944 insert into &lib..mpe_selectbox set
945 selectbox_rk=%mf_increment(rk)
946 ,ver_from_dttm=0
947 ,select_lib="&lib"
948 ,select_ds="MPE_VALIDATIONS"
949 ,base_column="RULE_TYPE"
950 ,selectbox_value="HARDREGEX"
951 ,selectbox_order=13
952 ,ver_to_dttm='31DEC5999:23:59:59'dt;
953 insert into &lib..mpe_selectbox set
954 selectbox_rk=%mf_increment(rk)
955 ,ver_from_dttm=0
956 ,select_lib="&lib"
957 ,select_ds="MPE_VALIDATIONS"
958 ,base_column="RULE_TYPE"
959 ,selectbox_value="SOFTREGEX"
960 ,selectbox_order=14
961 ,ver_to_dttm='31DEC5999:23:59:59'dt;
962 insert into &lib..mpe_selectbox set
963 selectbox_rk=%mf_increment(rk)
964 ,ver_from_dttm=0
965 ,select_lib="&lib"
966 ,select_ds="MPE_VALIDATIONS"
967 ,base_column="RULE_TYPE"
968 ,selectbox_value="HARDFORMULA"
969 ,selectbox_order=15
970 ,ver_to_dttm='31DEC5999:23:59:59'dt;
971 insert into &lib..mpe_selectbox set
972 selectbox_rk=%mf_increment(rk)
973 ,ver_from_dttm=0
974 ,select_lib="&lib"
975 ,select_ds="MPE_VALIDATIONS"
976 ,base_column="RULE_TYPE"
977 ,selectbox_value="SOFTFORMULA"
978 ,selectbox_order=16
979 ,ver_to_dttm='31DEC5999:23:59:59'dt;
980 insert into &lib..mpe_selectbox set
981 selectbox_rk=%mf_increment(rk)
982 ,ver_from_dttm=0
983 ,select_lib="&lib"
984 ,select_ds="MPE_VALIDATIONS"
985 ,base_column="RULE_ACTIVE"
986 ,selectbox_value="1"
987 ,selectbox_order=1
988 ,ver_to_dttm='31DEC5999:23:59:59'dt;
989 insert into &lib..mpe_selectbox set
990 selectbox_rk=%mf_increment(rk)
991 ,ver_from_dttm=0
992 ,select_lib="&lib"
993 ,select_ds="MPE_VALIDATIONS"
994 ,base_column="RULE_ACTIVE"
995 ,selectbox_value="0"
996 ,selectbox_order=2
997 ,ver_to_dttm='31DEC5999:23:59:59'dt;
998 insert into &lib..mpe_selectbox set
999 selectbox_rk=%mf_increment(rk)
1000 ,ver_from_dttm=0
1001 ,select_lib="&lib"
1002 ,select_ds="MPE_SECURITY"
1003 ,base_column="DSN"
1004 ,selectbox_value="*ALL*"
1005 ,selectbox_order=1
1006 ,ver_to_dttm='31DEC5999:23:59:59'dt;
1007 insert into &lib..mpe_selectbox set
1008 selectbox_rk=%mf_increment(rk)
1009 ,ver_from_dttm=0
1010 ,select_lib="&lib"
1011 ,select_ds="MPE_DATADICTIONARY"
1012 ,base_column="DD_TYPE"
1013 ,selectbox_value="COLUMN"
1014 ,selectbox_order=1
1015 ,ver_to_dttm='31DEC5999:23:59:59'dt;
1016 insert into &lib..mpe_selectbox set
1017 selectbox_rk=%mf_increment(rk)
1018 ,ver_from_dttm=0
1019 ,select_lib="&lib"
1020 ,select_ds="MPE_DATADICTIONARY"
1021 ,base_column="DD_TYPE"
1022 ,selectbox_value="TABLE"
1023 ,selectbox_order=2
1024 ,ver_to_dttm='31DEC5999:23:59:59'dt;
1025 insert into &lib..mpe_selectbox set
1026 selectbox_rk=%mf_increment(rk)
1027 ,ver_from_dttm=0
1028 ,select_lib="&lib"
1029 ,select_ds="MPE_DATADICTIONARY"
1030 ,base_column="DD_TYPE"
1031 ,selectbox_value="LIBRARY"
1032 ,selectbox_order=3
1033 ,ver_to_dttm='31DEC5999:23:59:59'dt;
1034 insert into &lib..mpe_selectbox set
1035 selectbox_rk=%mf_increment(rk)
1036 ,ver_from_dttm=0
1037 ,select_lib="&lib"
1038 ,select_ds="MPE_DATADICTIONARY"
1039 ,base_column="DD_TYPE"
1040 ,selectbox_value="CATALOG"
1041 ,selectbox_order=3
1042 ,ver_to_dttm='31DEC5999:23:59:59'dt;
1043 insert into &lib..mpe_selectbox set
1044 selectbox_rk=%mf_increment(rk)
1045 ,ver_from_dttm=0
1046 ,select_lib="&lib"
1047 ,select_ds="MPE_DATADICTIONARY"
1048 ,base_column="DD_TYPE"
1049 ,selectbox_value="FORMAT"
1050 ,selectbox_order=3
1051 ,ver_to_dttm='31DEC5999:23:59:59'dt;
1052 insert into &lib..mpe_selectbox set
1053 selectbox_rk=%mf_increment(rk)
1054 ,ver_from_dttm=0
1055 ,select_lib="&lib"
1056 ,select_ds="MPE_SECURITY"
1057 ,base_column="LIBREF"
1058 ,selectbox_value='*ALL*'
1059 ,selectbox_order=1
1060 ,ver_to_dttm='31DEC5999:23:59:59'dt;
1061 insert into &lib..mpe_selectbox set
1062 selectbox_rk=%mf_increment(rk)
1063 ,ver_from_dttm=0
1064 ,select_lib="&lib"
1065 ,select_ds="MPE_SECURITY"
1066 ,base_column="ACCESS_LEVEL"
1067 ,selectbox_value='AUDIT'
1068 ,selectbox_order=4
1069 ,ver_to_dttm='31DEC5999:23:59:59'dt;
1070 insert into &lib..mpe_selectbox set
1071 selectbox_rk=%mf_increment(rk)
1072 ,ver_from_dttm=0
1073 ,select_lib="&lib"
1074 ,select_ds="MPE_ROW_LEVEL_SECURITY"
1075 ,base_column="RLS_SCOPE"
1076 ,selectbox_value="ALL"
1077 ,selectbox_order=1
1078 ,ver_to_dttm='31DEC5999:23:59:59'dt;
1079 insert into &lib..mpe_selectbox set
1080 selectbox_rk=%mf_increment(rk)
1081 ,ver_from_dttm=0
1082 ,select_lib="&lib"
1083 ,select_ds="MPE_ROW_LEVEL_SECURITY"
1084 ,base_column="RLS_SCOPE"
1085 ,selectbox_value="EDIT"
1086 ,selectbox_order=1
1087 ,ver_to_dttm='31DEC5999:23:59:59'dt;
1088 insert into &lib..mpe_selectbox set
1089 selectbox_rk=%mf_increment(rk)
1090 ,ver_from_dttm=0
1091 ,select_lib="&lib"
1092 ,select_ds="MPE_ROW_LEVEL_SECURITY"
1093 ,base_column="RLS_SCOPE"
1094 ,selectbox_value="VIEW"
1095 ,selectbox_order=1
1096 ,ver_to_dttm='31DEC5999:23:59:59'dt;
1097 insert into &lib..mpe_selectbox set
1098 selectbox_rk=%mf_increment(rk)
1099 ,ver_from_dttm=0
1100 ,select_lib="&lib"
1101 ,select_ds="MPE_ROW_LEVEL_SECURITY"
1102 ,base_column="RLS_GROUP_LOGIC"
1103 ,selectbox_value="AND"
1104 ,selectbox_order=1
1105 ,ver_to_dttm='31DEC5999:23:59:59'dt;
1106 insert into &lib..mpe_selectbox set
1107 selectbox_rk=%mf_increment(rk)
1108 ,ver_from_dttm=0
1109 ,select_lib="&lib"
1110 ,select_ds="MPE_ROW_LEVEL_SECURITY"
1111 ,base_column="RLS_GROUP_LOGIC"
1112 ,selectbox_value="OR"
1113 ,selectbox_order=2
1114 ,ver_to_dttm='31DEC5999:23:59:59'dt;
1115 insert into &lib..mpe_selectbox set
1116 selectbox_rk=%mf_increment(rk)
1117 ,ver_from_dttm=0
1118 ,select_lib="&lib"
1119 ,select_ds="MPE_ROW_LEVEL_SECURITY"
1120 ,base_column="RLS_SUBGROUP_LOGIC"
1121 ,selectbox_value="AND"
1122 ,selectbox_order=1
1123 ,ver_to_dttm='31DEC5999:23:59:59'dt;
1124 insert into &lib..mpe_selectbox set
1125 selectbox_rk=%mf_increment(rk)
1126 ,ver_from_dttm=0
1127 ,select_lib="&lib"
1128 ,select_ds="MPE_ROW_LEVEL_SECURITY"
1129 ,base_column="RLS_SUBGROUP_LOGIC"
1130 ,selectbox_value="OR"
1131 ,selectbox_order=2
1132 ,ver_to_dttm='31DEC5999:23:59:59'dt;
1133 insert into &lib..mpe_selectbox set
1134 selectbox_rk=%mf_increment(rk)
1135 ,ver_from_dttm=0
1136 ,select_lib="&lib"
1137 ,select_ds="MPE_ROW_LEVEL_SECURITY"
1138 ,base_column="RLS_OPERATOR_NM"
1139 ,selectbox_value="="
1140 ,selectbox_order=0
1141 ,ver_to_dttm='31DEC5999:23:59:59'dt;
1142 insert into &lib..mpe_selectbox set
1143 selectbox_rk=%mf_increment(rk)
1144 ,ver_from_dttm=0
1145 ,select_lib="&lib"
1146 ,select_ds="MPE_ROW_LEVEL_SECURITY"
1147 ,base_column="RLS_OPERATOR_NM"
1148 ,selectbox_value=">"
1149 ,selectbox_order=1
1150 ,ver_to_dttm='31DEC5999:23:59:59'dt;
1151 insert into &lib..mpe_selectbox set
1152 selectbox_rk=%mf_increment(rk)
1153 ,ver_from_dttm=0
1154 ,select_lib="&lib"
1155 ,select_ds="MPE_ROW_LEVEL_SECURITY"
1156 ,base_column="RLS_OPERATOR_NM"
1157 ,selectbox_value="<"
1158 ,selectbox_order=1
1159 ,ver_to_dttm='31DEC5999:23:59:59'dt;
1160 insert into &lib..mpe_selectbox set
1161 selectbox_rk=%mf_increment(rk)
1162 ,ver_from_dttm=0
1163 ,select_lib="&lib"
1164 ,select_ds="MPE_ROW_LEVEL_SECURITY"
1165 ,base_column="RLS_OPERATOR_NM"
1166 ,selectbox_value="<="
1167 ,selectbox_order=1
1168 ,ver_to_dttm='31DEC5999:23:59:59'dt;
1169 insert into &lib..mpe_selectbox set
1170 selectbox_rk=%mf_increment(rk)
1171 ,ver_from_dttm=0
1172 ,select_lib="&lib"
1173 ,select_ds="MPE_ROW_LEVEL_SECURITY"
1174 ,base_column="RLS_OPERATOR_NM"
1175 ,selectbox_value=">="
1176 ,selectbox_order=1
1177 ,ver_to_dttm='31DEC5999:23:59:59'dt;
1178 insert into &lib..mpe_selectbox set
1179 selectbox_rk=%mf_increment(rk)
1180 ,ver_from_dttm=0
1181 ,select_lib="&lib"
1182 ,select_ds="MPE_ROW_LEVEL_SECURITY"
1183 ,base_column="RLS_OPERATOR_NM"
1184 ,selectbox_value="BETWEEN"
1185 ,selectbox_order=1
1186 ,ver_to_dttm='31DEC5999:23:59:59'dt;
1187 insert into &lib..mpe_selectbox set
1188 selectbox_rk=%mf_increment(rk)
1189 ,ver_from_dttm=0
1190 ,select_lib="&lib"
1191 ,select_ds="MPE_ROW_LEVEL_SECURITY"
1192 ,base_column="RLS_OPERATOR_NM"
1193 ,selectbox_value="IN"
1194 ,selectbox_order=1
1195 ,ver_to_dttm='31DEC5999:23:59:59'dt;
1196 insert into &lib..mpe_selectbox set
1197 selectbox_rk=%mf_increment(rk)
1198 ,ver_from_dttm=0
1199 ,select_lib="&lib"
1200 ,select_ds="MPE_ROW_LEVEL_SECURITY"
1201 ,base_column="RLS_OPERATOR_NM"
1202 ,selectbox_value="NOT IN"
1203 ,selectbox_order=1
1204 ,ver_to_dttm='31DEC5999:23:59:59'dt;
1205 insert into &lib..mpe_selectbox set
1206 selectbox_rk=%mf_increment(rk)
1207 ,ver_from_dttm=0
1208 ,select_lib="&lib"
1209 ,select_ds="MPE_ROW_LEVEL_SECURITY"
1210 ,base_column="RLS_OPERATOR_NM"
1211 ,selectbox_value="NE"
1212 ,selectbox_order=1
1213 ,ver_to_dttm='31DEC5999:23:59:59'dt;
1214 insert into &lib..mpe_selectbox set
1215 selectbox_rk=%mf_increment(rk)
1216 ,ver_from_dttm=0
1217 ,select_lib="&lib"
1218 ,select_ds="MPE_ROW_LEVEL_SECURITY"
1219 ,base_column="RLS_OPERATOR_NM"
1220 ,selectbox_value="CONTAINS"
1221 ,selectbox_order=1
1222 ,ver_to_dttm='31DEC5999:23:59:59'dt;
1223 insert into &lib..mpe_selectbox set
1224 selectbox_rk=%mf_increment(rk)
1225 ,ver_from_dttm=0
1226 ,select_lib="&lib"
1227 ,select_ds="MPE_EXCEL_CONFIG"
1228 ,base_column="XL_RULE"
1229 ,selectbox_value="FORMULA"
1230 ,selectbox_order=1
1231 ,ver_to_dttm='31DEC5999:23:59:59'dt;
1232 insert into &lib..mpe_selectbox set
1233 selectbox_rk=%mf_increment(rk)
1234 ,ver_from_dttm=0
1235 ,select_lib="&lib"
1236 ,select_ds="MPE_ROW_LEVEL_SECURITY"
1237 ,base_column="RLS_ACTIVE"
1238 ,selectbox_value="1"
1239 ,selectbox_order=1
1240 ,ver_to_dttm='31DEC5999:23:59:59'dt;
1241 insert into &lib..mpe_selectbox set
1242 selectbox_rk=%mf_increment(rk)
1243 ,ver_from_dttm=0
1244 ,select_lib="&lib"
1245 ,select_ds="MPE_ROW_LEVEL_SECURITY"
1246 ,base_column="RLS_ACTIVE"
1247 ,selectbox_value="0"
1248 ,selectbox_order=2
1249 ,ver_to_dttm='31DEC5999:23:59:59'dt;
1250 insert into &lib..mpe_selectbox set
1251 selectbox_rk=%mf_increment(rk)
1252 ,ver_from_dttm=0
1253 ,select_lib="&lib"
1254 ,select_ds="MPE_COLUMN_LEVEL_SECURITY"
1255 ,base_column="CLS_ACTIVE"
1256 ,selectbox_value="1"
1257 ,selectbox_order=1
1258 ,ver_to_dttm='31DEC5999:23:59:59'dt;
1259 insert into &lib..mpe_selectbox set
1260 selectbox_rk=%mf_increment(rk)
1261 ,ver_from_dttm=0
1262 ,select_lib="&lib"
1263 ,select_ds="MPE_COLUMN_LEVEL_SECURITY"
1264 ,base_column="CLS_ACTIVE"
1265 ,selectbox_value="0"
1266 ,selectbox_order=2
1267 ,ver_to_dttm='31DEC5999:23:59:59'dt;
1268 insert into &lib..mpe_selectbox set
1269 selectbox_rk=%mf_increment(rk)
1270 ,ver_from_dttm=0
1271 ,select_lib="&lib"
1272 ,select_ds="MPE_COLUMN_LEVEL_SECURITY"
1273 ,base_column="CLS_SCOPE"
1274 ,selectbox_value="EDIT"
1275 ,selectbox_order=1
1276 ,ver_to_dttm='31DEC5999:23:59:59'dt;
1277 insert into &lib..mpe_selectbox set
1278 selectbox_rk=%mf_increment(rk)
1279 ,ver_from_dttm=0
1280 ,select_lib="&lib"
1281 ,select_ds="MPE_COLUMN_LEVEL_SECURITY"
1282 ,base_column="CLS_SCOPE"
1283 ,selectbox_value="VIEW"
1284 ,selectbox_order=2
1285 ,ver_to_dttm='31DEC5999:23:59:59'dt;
1286 insert into &lib..mpe_selectbox set
1287 selectbox_rk=%mf_increment(rk)
1288 ,ver_from_dttm=0
1289 ,select_lib="&lib"
1290 ,select_ds="MPE_COLUMN_LEVEL_SECURITY"
1291 ,base_column="CLS_SCOPE"
1292 ,selectbox_value="ALL"
1293 ,selectbox_order=3
1294 ,ver_to_dttm='31DEC5999:23:59:59'dt;
1295 insert into &lib..mpe_selectbox set
1296 selectbox_rk=%mf_increment(rk)
1297 ,ver_from_dttm=0
1298 ,select_lib="&lib"
1299 ,select_ds="MPE_COLUMN_LEVEL_SECURITY"
1300 ,base_column="CLS_HIDE"
1301 ,selectbox_value="0"
1302 ,selectbox_order=1
1303 ,ver_to_dttm='31DEC5999:23:59:59'dt;
1304 insert into &lib..mpe_selectbox set
1305 selectbox_rk=%mf_increment(rk)
1306 ,ver_from_dttm=0
1307 ,select_lib="&lib"
1308 ,select_ds="MPE_COLUMN_LEVEL_SECURITY"
1309 ,base_column="CLS_HIDE"
1310 ,selectbox_value="1"
1311 ,selectbox_order=2
1312 ,ver_to_dttm='31DEC5999:23:59:59'dt;
1313
1314/**
1315 * MPE_TABLES
1316 */
1317 insert into &lib..mpe_tables
1318 set tx_from=0
1319 ,tx_to='31DEC5999:23:59:59'dt
1320 ,libref="&lib"
1321 ,dsn='MPE_COLUMN_LEVEL_SECURITY'
1322 ,num_of_approvals_required=1
1323 ,loadtype='TXTEMPORAL'
1324 ,var_txfrom='TX_FROM'
1325 ,var_txto='TX_TO'
1326 ,buskey='CLS_SCOPE CLS_GROUP CLS_LIBREF CLS_TABLE CLS_VARIABLE_NM'
1327 ,notes='Docs: https://docs.datacontroller.io/column-level-security'
1328 ,post_edit_hook='services/hooks/mpe_column_level_security_postedit'
1329 ;
1330 insert into &lib..mpe_tables
1331 set tx_from=0
1332 ,tx_to='31DEC5999:23:59:59'dt
1333 ,libref="&lib"
1334 ,dsn='MPE_XLMAP_INFO'
1335 ,num_of_approvals_required=1
1336 ,loadtype='TXTEMPORAL'
1337 ,var_txfrom='TX_FROM'
1338 ,var_txto='TX_TO'
1339 ,buskey='XLMAP_ID'
1340 ,notes='Docs: https://docs.datacontroller.io/complex-excel-uploads'
1341 ,post_edit_hook='services/hooks/mpe_xlmap_info_postedit'
1342 ;
1343 insert into &lib..mpe_tables
1344 set tx_from=0
1345 ,tx_to='31DEC5999:23:59:59'dt
1346 ,libref="&lib"
1347 ,dsn='MPE_XLMAP_RULES'
1348 ,num_of_approvals_required=1
1349 ,loadtype='TXTEMPORAL'
1350 ,var_txfrom='TX_FROM'
1351 ,var_txto='TX_TO'
1352 ,buskey='XLMAP_ID XLMAP_RANGE_ID'
1353 ,notes='Docs: https://docs.datacontroller.io/complex-excel-uploads'
1354 ,post_edit_hook='services/hooks/mpe_xlmap_rules_postedit'
1355 ;
1356 insert into &lib..mpe_tables
1357 set tx_from=0
1358 ,tx_to='31DEC5999:23:59:59'dt
1359 ,libref="&lib"
1360 ,dsn='MPE_XLMAP_DATA'
1361 ,num_of_approvals_required=1
1362 ,loadtype='UPDATE'
1363 ,buskey='LOAD_REF XLMAP_ID XLMAP_RANGE_ID ROW_NO COL_NO'
1364 ,notes='Docs: https://docs.datacontroller.io/complex-excel-uploads'
1365 ;
1366 insert into &lib..mpe_tables
1367 set tx_from=0
1368 ,tx_to='31DEC5999:23:59:59'dt
1369 ,libref="&lib"
1370 ,dsn='MPE_LOCKANYTABLE'
1371 ,num_of_approvals_required=1
1372 ,loadtype='UPDATE'
1373 ,buskey='LOCK_LIB LOCK_DS'
1374 ,notes='This table may be edited when a process failed and left a lock'
1375 ;
1376 insert into &lib..mpe_tables
1377 set tx_from=0
1378 ,tx_to='31DEC5999:23:59:59'dt
1379 ,libref="&lib"
1380 ,dsn='MPE_TABLES'
1381 ,num_of_approvals_required=1
1382 ,loadtype='TXTEMPORAL'
1383 ,buskey='LIBREF DSN'
1384 ,var_txfrom='TX_FROM'
1385 ,var_txto='TX_TO'
1386 ,notes='This entry allows the MP Editor to edit itself!'
1387 ,post_edit_hook='services/hooks/mpe_tables_postedit'
1388 ;
1389 insert into &lib..mpe_tables
1390 set tx_from=0
1391 ,tx_to='31DEC5999:23:59:59'dt
1392 ,libref="&lib"
1393 ,dsn='MPE_SECURITY'
1394 ,num_of_approvals_required=1
1395 ,loadtype='TXTEMPORAL'
1396 ,buskey='LIBREF DSN ACCESS_LEVEL SAS_GROUP'
1397 ,var_txfrom='TX_FROM'
1398 ,var_txto='TX_TO'
1399 ,notes='Determines which groups can view/edit/approve which tables'
1400 ,post_edit_hook='services/hooks/mpe_security_postedit'
1401 ;
1402 insert into &lib..mpe_tables
1403 set tx_from=0
1404 ,tx_to='31DEC5999:23:59:59'dt
1405 ,libref="&lib"
1406 ,dsn='MPE_SELECTBOX'
1407 ,num_of_approvals_required=1
1408 ,loadtype='TXTEMPORAL'
1409 ,buskey='SELECTBOX_RK'
1410 ,var_txfrom='VER_FROM_DTTM'
1411 ,var_txto='VER_TO_DTTM'
1412 ,notes='Can configure dropdowns for the front end'
1413 ,rk_underlying='SELECT_LIB SELECT_DS BASE_COLUMN SELECTBOX_VALUE'
1414 ;
1415 insert into &lib..mpe_tables
1416 set tx_from=0
1417 ,tx_to='31DEC5999:23:59:59'dt
1418 ,libref="&lib"
1419 ,dsn='MPE_X_TEST'
1420 ,num_of_approvals_required=1
1421 ,loadtype='UPDATE'
1422 ,buskey='PRIMARY_KEY_FIELD'
1423 ,notes='Test table for controller'
1424 ;
1425 insert into &lib..mpe_tables
1426 set tx_from=0
1427 ,tx_to='31DEC5999:23:59:59'dt
1428 ,libref="&lib"
1429 ,dsn='MPE_EMAILS'
1430 ,num_of_approvals_required=1
1431 ,loadtype='TXTEMPORAL'
1432 ,buskey='USER_NAME'
1433 ,notes='Primary Emails Table (backup is metadata)'
1434 ,var_txfrom='TX_FROM'
1435 ,var_txto='TX_TO'
1436 ;
1437 insert into &lib..mpe_tables
1438 set tx_from=0
1439 ,tx_to='31DEC5999:23:59:59'dt
1440 ,libref="&lib"
1441 ,dsn='MPE_CONFIG'
1442 ,num_of_approvals_required=1
1443 ,loadtype='TXTEMPORAL'
1444 ,buskey='VAR_SCOPE VAR_NAME'
1445 ,notes='Configuration variables for Data Controller'
1446 ,var_txfrom='TX_FROM'
1447 ,var_txto='TX_TO'
1448 ;
1449 insert into &lib..mpe_tables
1450 set tx_from=0
1451 ,tx_to='31DEC5999:23:59:59'dt
1452 ,libref="&lib"
1453 ,dsn='MPE_ALERTS'
1454 ,num_of_approvals_required=1
1455 ,loadtype='TXTEMPORAL'
1456 ,buskey='ALERT_EVENT ALERT_LIB ALERT_DS ALERT_USER'
1457 ,notes='Configuration for alert email events'
1458 ,var_txfrom='TX_FROM'
1459 ,var_txto='TX_TO'
1460 ;
1461 insert into &lib..mpe_tables
1462 set tx_from=0
1463 ,tx_to='31DEC5999:23:59:59'dt
1464 ,libref="&lib"
1465 ,dsn='MPE_GROUPS'
1466 ,num_of_approvals_required=1
1467 ,loadtype='TXTEMPORAL'
1468 ,buskey='GROUP_NAME USER_NAME'
1469 ,notes='Configuration for additional groups within Data Controller'
1470 ,var_txfrom='TX_FROM'
1471 ,var_txto='TX_TO'
1472 ;
1473 insert into &lib..mpe_tables
1474 set tx_from=0
1475 ,tx_to='31DEC5999:23:59:59'dt
1476 ,libref="&lib"
1477 ,dsn='MPE_VALIDATIONS'
1478 ,num_of_approvals_required=1
1479 ,loadtype='TXTEMPORAL'
1480 ,buskey='BASE_LIB BASE_DS BASE_COL RULE_TYPE'
1481 ,notes='Configuration of data quality rules in Editor component'
1482 ,var_txfrom='TX_FROM'
1483 ,var_txto='TX_TO'
1484 ,post_edit_hook='services/hooks/mpe_validations_postedit'
1485 ;
1486 insert into &lib..mpe_tables
1487 set tx_from=0
1488 ,tx_to='31DEC5999:23:59:59'dt
1489 ,libref="&lib"
1490 ,dsn='MPE_DATADICTIONARY'
1491 ,num_of_approvals_required=1
1492 ,loadtype='TXTEMPORAL'
1493 ,buskey='DD_TYPE DD_SOURCE'
1494 ,notes='Configuration of data dictionary'
1495 ,var_txfrom='TX_FROM'
1496 ,var_txto='TX_TO'
1497 ;
1498 insert into &lib..mpe_tables
1499 set tx_from=0
1500 ,tx_to='31DEC5999:23:59:59'dt
1501 ,libref="&lib"
1502 ,dsn='MPE_EXCEL_CONFIG'
1503 ,num_of_approvals_required=1
1504 ,loadtype='TXTEMPORAL'
1505 ,buskey='XL_LIBREF XL_TABLE XL_COLUMN'
1506 ,notes='Configuration of the excel import rules'
1507 ,var_txfrom='TX_FROM'
1508 ,var_txto='TX_TO'
1509 ;
1510 insert into &lib..mpe_tables
1511 set tx_from=0
1512 ,tx_to='31DEC5999:23:59:59'dt
1513 ,libref="&lib"
1514 ,dsn='MPE_ROW_LEVEL_SECURITY'
1515 ,num_of_approvals_required=1
1516 ,loadtype='TXTEMPORAL'
1517 ,buskey='RLS_RK'
1518 ,notes='Configuration of Row Level Security'
1519 ,var_txfrom='TX_FROM'
1520 ,var_txto='TX_TO'
1521 ,rk_underlying='RLS_SCOPE RLS_GROUP RLS_LIBREF RLS_TABLE RLS_GROUP_LOGIC '
1522 !!'RLS_SUBGROUP_LOGIC RLS_SUBGROUP_ID RLS_VARIABLE_NM RLS_OPERATOR_NM '
1523 !!'RLS_RAW_VALUE '
1524 ,post_edit_hook='services/hooks/mpe_row_level_security_postedit'
1525 ;
1526 insert into &lib..mpe_tables
1527 set tx_from=0
1528 ,tx_to='31DEC5999:23:59:59'dt
1529 ,libref="&lib"
1530 ,dsn='MPE_X_CATALOG-FC'
1531 ,num_of_approvals_required=1
1532 ,loadtype='FORMAT_CAT'
1533 ,buskey='TYPE FMTNAME FMTROW'
1534 ,notes='Sample Format Catalog'
1535 ;
1536
1537/* mpe_validations */
1538insert into &lib..MPE_VALIDATIONS set
1539 tx_from=0
1540 ,base_lib="&lib"
1541 ,base_ds="MPE_COLUMN_LEVEL_SECURITY"
1542 ,base_col="CLS_SCOPE"
1543 ,rule_type='CASE'
1544 ,rule_value='UPCASE'
1545 ,rule_active=1
1546 ,tx_to='31DEC5999:23:59:59'dt;
1547insert into &lib..MPE_VALIDATIONS set
1548 tx_from=0
1549 ,base_lib="&lib"
1550 ,base_ds="MPE_COLUMN_LEVEL_SECURITY"
1551 ,base_col="CLS_LIBREF"
1552 ,rule_type='CASE'
1553 ,rule_value='UPCASE'
1554 ,rule_active=1
1555 ,tx_to='31DEC5999:23:59:59'dt;
1556insert into &lib..MPE_VALIDATIONS set
1557 tx_from=0
1558 ,base_lib="&lib"
1559 ,base_ds="MPE_COLUMN_LEVEL_SECURITY"
1560 ,base_col="CLS_LIBREF"
1561 ,rule_type='SOFTSELECT_HOOK'
1562 ,rule_value="services/validations/libraries_all"
1563 ,rule_active=1
1564 ,tx_to='31DEC5999:23:59:59'dt;
1565insert into &lib..MPE_VALIDATIONS set
1566 tx_from=0
1567 ,base_lib="&lib"
1568 ,base_ds="MPE_COLUMN_LEVEL_SECURITY"
1569 ,base_col="CLS_TABLE"
1570 ,rule_type='CASE'
1571 ,rule_value='UPCASE'
1572 ,rule_active=1
1573 ,tx_to='31DEC5999:23:59:59'dt;
1574insert into &lib..MPE_VALIDATIONS set
1575 tx_from=0
1576 ,base_lib="&lib"
1577 ,base_ds="MPE_COLUMN_LEVEL_SECURITY"
1578 ,base_col="CLS_TABLE"
1579 ,rule_type='SOFTSELECT_HOOK'
1580 ,rule_value="services/validations/tables_all"
1581 ,rule_active=1
1582 ,tx_to='31DEC5999:23:59:59'dt;
1583insert into &lib..MPE_VALIDATIONS set
1584 tx_from=0
1585 ,base_lib="&lib"
1586 ,base_ds="MPE_COLUMN_LEVEL_SECURITY"
1587 ,base_col="CLS_VARIABLE_NM"
1588 ,rule_type='CASE'
1589 ,rule_value='UPCASE'
1590 ,rule_active=1
1591 ,tx_to='31DEC5999:23:59:59'dt;
1592insert into &lib..MPE_VALIDATIONS set
1593 tx_from=0
1594 ,base_lib="&lib"
1595 ,base_ds="MPE_COLUMN_LEVEL_SECURITY"
1596 ,base_col="CLS_VARIABLE_NM"
1597 ,rule_type='SOFTSELECT_HOOK'
1598 ,rule_value="services/validations/columns_in_libds"
1599 ,rule_active=1
1600 ,tx_to='31DEC5999:23:59:59'dt;
1601insert into &lib..MPE_VALIDATIONS set
1602 tx_from=0
1603 ,base_lib="&lib"
1604 ,base_ds="MPE_COLUMN_LEVEL_SECURITY"
1605 ,base_col="CLS_ACTIVE"
1606 ,rule_type='MAXVAL'
1607 ,rule_value='1'
1608 ,rule_active=1
1609 ,tx_to='31DEC5999:23:59:59'dt;
1610insert into &lib..MPE_VALIDATIONS set
1611 tx_from=0
1612 ,base_lib="&lib"
1613 ,base_ds="MPE_COLUMN_LEVEL_SECURITY"
1614 ,base_col="CLS_HIDE"
1615 ,rule_type='MAXVAL'
1616 ,rule_value='1'
1617 ,rule_active=1
1618 ,tx_to='31DEC5999:23:59:59'dt;
1619insert into &lib..MPE_VALIDATIONS set
1620 tx_from=0
1621 ,base_lib="&lib"
1622 ,base_ds="MPE_COLUMN_LEVEL_SECURITY"
1623 ,base_col="CLS_GROUP"
1624 ,rule_type='SOFTSELECT_HOOK'
1625 ,rule_value="services/validations/sas_groups"
1626 ,rule_active=1
1627 ,tx_to='31DEC5999:23:59:59'dt;
1628
1629insert into &lib..MPE_VALIDATIONS set
1630 tx_from=0
1631 ,base_lib="&lib"
1632 ,base_ds="MPE_ALERTS"
1633 ,base_col="ALERT_LIB"
1634 ,rule_type='HARDSELECT_HOOK'
1635 ,rule_value="services/validations/mpe_alerts.alert_lib"
1636 ,rule_active=1
1637 ,tx_to='31DEC5999:23:59:59'dt;
1638
1639insert into &lib..MPE_VALIDATIONS set
1640 tx_from=0
1641 ,base_lib="&lib"
1642 ,base_ds="MPE_XLMAP_INFO"
1643 ,base_col="XLMAP_ID"
1644 ,rule_type='CASE'
1645 ,rule_value='UPCASE'
1646 ,rule_active=1
1647 ,tx_to='31DEC5999:23:59:59'dt;
1648
1649insert into &lib..MPE_VALIDATIONS set
1650 tx_from=0
1651 ,base_lib="&lib"
1652 ,base_ds="MPE_XLMAP_RULES"
1653 ,base_col="XLMAP_ID"
1654 ,rule_type='CASE'
1655 ,rule_value='UPCASE'
1656 ,rule_active=1
1657 ,tx_to='31DEC5999:23:59:59'dt;
1658
1659insert into &lib..MPE_VALIDATIONS set
1660 tx_from=0
1661 ,base_lib="&lib"
1662 ,base_ds="MPE_TABLES"
1663 ,base_col="LIBREF"
1664 ,rule_type='CASE'
1665 ,rule_value='UPCASE'
1666 ,rule_active=1
1667 ,tx_to='31DEC5999:23:59:59'dt;
1668insert into &lib..MPE_VALIDATIONS set
1669 tx_from=0
1670 ,base_lib="&lib"
1671 ,base_ds="MPE_TABLES"
1672 ,base_col="DSN"
1673 ,rule_type='CASE'
1674 ,rule_value='UPCASE'
1675 ,rule_active=1
1676 ,tx_to='31DEC5999:23:59:59'dt;
1677insert into &lib..MPE_VALIDATIONS set
1678 tx_from=0
1679 ,base_lib="&lib"
1680 ,base_ds="MPE_TABLES"
1681 ,base_col="LIBREF"
1682 ,rule_type='NOTNULL'
1683 ,rule_value=' '
1684 ,rule_active=1
1685 ,tx_to='31DEC5999:23:59:59'dt;
1686insert into &lib..MPE_VALIDATIONS set
1687 tx_from=0
1688 ,base_lib="&lib"
1689 ,base_ds="MPE_TABLES"
1690 ,base_col="DSN"
1691 ,rule_type='NOTNULL'
1692 ,rule_value=' '
1693 ,rule_active=1
1694 ,tx_to='31DEC5999:23:59:59'dt;
1695insert into &lib..MPE_VALIDATIONS set
1696 tx_from=0
1697 ,base_lib="&lib"
1698 ,base_ds="MPE_TABLES"
1699 ,base_col="NUM_OF_APPROVALS_REQUIRED"
1700 ,rule_type='MINVAL'
1701 ,rule_value='1'
1702 ,rule_active=1
1703 ,tx_to='31DEC5999:23:59:59'dt;
1704insert into &lib..MPE_VALIDATIONS set
1705 tx_from=0
1706 ,base_lib="&lib"
1707 ,base_ds="MPE_TABLES"
1708 ,base_col="BUSKEY"
1709 ,rule_type='CASE'
1710 ,rule_value='UPCASE'
1711 ,rule_active=1
1712 ,tx_to='31DEC5999:23:59:59'dt;
1713insert into &lib..MPE_VALIDATIONS set
1714 tx_from=0
1715 ,base_lib="&lib"
1716 ,base_ds="MPE_TABLES"
1717 ,base_col="BUSKEY"
1718 ,rule_type='NOTNULL'
1719 ,rule_value=" "
1720 ,rule_active=1
1721 ,tx_to='31DEC5999:23:59:59'dt;
1722insert into &lib..MPE_VALIDATIONS set
1723 tx_from=0
1724 ,base_lib="&lib"
1725 ,base_ds="MPE_TABLES"
1726 ,base_col="VAR_TXFROM"
1727 ,rule_type='CASE'
1728 ,rule_value='UPCASE'
1729 ,rule_active=1
1730 ,tx_to='31DEC5999:23:59:59'dt;
1731insert into &lib..MPE_VALIDATIONS set
1732 tx_from=0
1733 ,base_lib="&lib"
1734 ,base_ds="MPE_TABLES"
1735 ,base_col="VAR_TXTO"
1736 ,rule_type='CASE'
1737 ,rule_value='UPCASE'
1738 ,rule_active=1
1739 ,tx_to='31DEC5999:23:59:59'dt;
1740insert into &lib..MPE_VALIDATIONS set
1741 tx_from=0
1742 ,base_lib="&lib"
1743 ,base_ds="MPE_TABLES"
1744 ,base_col="VAR_BUSFROM"
1745 ,rule_type='CASE'
1746 ,rule_value='UPCASE'
1747 ,rule_active=1
1748 ,tx_to='31DEC5999:23:59:59'dt;
1749insert into &lib..MPE_VALIDATIONS set
1750 tx_from=0
1751 ,base_lib="&lib"
1752 ,base_ds="MPE_TABLES"
1753 ,base_col="VAR_BUSTO"
1754 ,rule_type='CASE'
1755 ,rule_value='UPCASE'
1756 ,rule_active=1
1757 ,tx_to='31DEC5999:23:59:59'dt;
1758insert into &lib..MPE_VALIDATIONS set
1759 tx_from=0
1760 ,base_lib="&lib"
1761 ,base_ds="MPE_SECURITY"
1762 ,base_col="LIBREF"
1763 ,rule_type='CASE'
1764 ,rule_value="UPCASE"
1765 ,rule_active=1
1766 ,tx_to='31DEC5999:23:59:59'dt;
1767insert into &lib..MPE_VALIDATIONS set
1768 tx_from=0
1769 ,base_lib="&lib"
1770 ,base_ds="MPE_TABLES"
1771 ,base_col="VAR_PROCESSED"
1772 ,rule_type='CASE'
1773 ,rule_value='UPCASE'
1774 ,rule_active=1
1775 ,tx_to='31DEC5999:23:59:59'dt;
1776insert into &lib..MPE_VALIDATIONS set
1777 tx_from=0
1778 ,base_lib="&lib"
1779 ,base_ds="MPE_SECURITY"
1780 ,base_col="LIBREF"
1781 ,rule_type='HARDSELECT'
1782 ,rule_value="&lib..MPE_TABLES.LIBREF"
1783 ,rule_active=1
1784 ,tx_to='31DEC5999:23:59:59'dt;
1785insert into &lib..MPE_VALIDATIONS set
1786 tx_from=0
1787 ,base_lib="&lib"
1788 ,base_ds="MPE_SECURITY"
1789 ,base_col="DSN"
1790 ,rule_type='CASE'
1791 ,rule_value="UPCASE"
1792 ,rule_active=1
1793 ,tx_to='31DEC5999:23:59:59'dt;
1794insert into &lib..MPE_VALIDATIONS set
1795 tx_from=0
1796 ,base_lib="&lib"
1797 ,base_ds="MPE_SECURITY"
1798 ,base_col="DSN"
1799 ,rule_type='SOFTSELECT'
1800 ,rule_value="&lib..MPE_TABLES.DSN"
1801 ,rule_active=1
1802 ,tx_to='31DEC5999:23:59:59'dt;
1803insert into &lib..MPE_VALIDATIONS set
1804 tx_from=0
1805 ,base_lib="&lib"
1806 ,base_ds="MPE_SECURITY"
1807 ,base_col="SAS_GROUP"
1808 ,rule_type='SOFTSELECT_HOOK'
1809 ,rule_value="services/validations/sas_groups"
1810 ,rule_active=1
1811 ,tx_to='31DEC5999:23:59:59'dt;
1812insert into &lib..MPE_VALIDATIONS set
1813 tx_from=0
1814 ,base_lib="&lib"
1815 ,base_ds="MPE_VALIDATIONS"
1816 ,base_col="BASE_LIB"
1817 ,rule_type='SOFTSELECT_HOOK'
1818 ,rule_value="services/validations/libraries_editable"
1819 ,rule_active=1
1820 ,tx_to='31DEC5999:23:59:59'dt;
1821insert into &lib..MPE_VALIDATIONS set
1822 tx_from=0
1823 ,base_lib="&lib"
1824 ,base_ds="MPE_VALIDATIONS"
1825 ,base_col="BASE_DS"
1826 ,rule_type='SOFTSELECT_HOOK'
1827 ,rule_value="services/validations/tables_editable"
1828 ,rule_active=1
1829 ,tx_to='31DEC5999:23:59:59'dt;
1830insert into &lib..MPE_VALIDATIONS set
1831 tx_from=0
1832 ,base_lib="&lib"
1833 ,base_ds="MPE_VALIDATIONS"
1834 ,base_col="BASE_COL"
1835 ,rule_type='SOFTSELECT_HOOK'
1836 ,rule_value="services/validations/columns_in_libds"
1837 ,rule_active=1
1838 ,tx_to='31DEC5999:23:59:59'dt;
1839insert into &lib..MPE_VALIDATIONS set
1840 tx_from=0
1841 ,base_lib="&lib"
1842 ,base_ds="MPE_VALIDATIONS"
1843 ,base_col="RULE_ACTIVE"
1844 ,rule_type='MINVAL'
1845 ,rule_value="0"
1846 ,rule_active=1
1847 ,tx_to='31DEC5999:23:59:59'dt;
1848insert into &lib..MPE_VALIDATIONS set
1849 tx_from=0
1850 ,base_lib="&lib"
1851 ,base_ds="MPE_VALIDATIONS"
1852 ,base_col="RULE_ACTIVE"
1853 ,rule_type='MAXVAL'
1854 ,rule_value="1"
1855 ,rule_active=1
1856 ,tx_to='31DEC5999:23:59:59'dt;
1857insert into &lib..MPE_VALIDATIONS set
1858 tx_from=0
1859 ,base_lib="&lib"
1860 ,base_ds="MPE_EXCEL_CONFIG"
1861 ,base_col="XL_LIBREF"
1862 ,rule_type='SOFTSELECT_HOOK'
1863 ,rule_value="services/validations/libraries_editable"
1864 ,rule_active=1
1865 ,tx_to='31DEC5999:23:59:59'dt;
1866insert into &lib..MPE_VALIDATIONS set
1867 tx_from=0
1868 ,base_lib="&lib"
1869 ,base_ds="MPE_EXCEL_CONFIG"
1870 ,base_col="XL_TABLE"
1871 ,rule_type='SOFTSELECT_HOOK'
1872 ,rule_value="services/validations/tables_editable"
1873 ,rule_active=1
1874 ,tx_to='31DEC5999:23:59:59'dt;
1875insert into &lib..MPE_VALIDATIONS set
1876 tx_from=0
1877 ,base_lib="&lib"
1878 ,base_ds="MPE_EXCEL_CONFIG"
1879 ,base_col="XL_COLUMN"
1880 ,rule_type='SOFTSELECT_HOOK'
1881 ,rule_value="services/validations/columns_in_libds"
1882 ,rule_active=1
1883 ,tx_to='31DEC5999:23:59:59'dt;
1884insert into &lib..MPE_VALIDATIONS set
1885 tx_from=0
1886 ,base_lib="&lib"
1887 ,base_ds="MPE_TABLES"
1888 ,base_col="LIBREF"
1889 ,rule_type='SOFTSELECT_HOOK'
1890 ,rule_value="services/validations/libraries_all"
1891 ,rule_active=1
1892 ,tx_to='31DEC5999:23:59:59'dt;
1893insert into &lib..MPE_VALIDATIONS set
1894 tx_from=0
1895 ,base_lib="&lib"
1896 ,base_ds="MPE_TABLES"
1897 ,base_col="DSN"
1898 ,rule_type='SOFTSELECT_HOOK'
1899 ,rule_value="services/validations/mpe_tables.dsn"
1900 ,rule_active=1
1901 ,tx_to='31DEC5999:23:59:59'dt;
1902insert into &lib..MPE_VALIDATIONS set
1903 tx_from=0
1904 ,base_lib="&lib"
1905 ,base_ds="MPE_TABLES"
1906 ,base_col="VAR_TXFROM"
1907 ,rule_type='SOFTSELECT_HOOK'
1908 ,rule_value="services/validations/columns_in_libds"
1909 ,rule_active=1
1910 ,tx_to='31DEC5999:23:59:59'dt;
1911insert into &lib..MPE_VALIDATIONS set
1912 tx_from=0
1913 ,base_lib="&lib"
1914 ,base_ds="MPE_TABLES"
1915 ,base_col="VAR_TXTO"
1916 ,rule_type='SOFTSELECT_HOOK'
1917 ,rule_value="services/validations/columns_in_libds"
1918 ,rule_active=1
1919 ,tx_to='31DEC5999:23:59:59'dt;
1920insert into &lib..MPE_VALIDATIONS set
1921 tx_from=0
1922 ,base_lib="&lib"
1923 ,base_ds="MPE_TABLES"
1924 ,base_col="VAR_BUSFROM"
1925 ,rule_type='SOFTSELECT_HOOK'
1926 ,rule_value="services/validations/columns_in_libds"
1927 ,rule_active=1
1928 ,tx_to='31DEC5999:23:59:59'dt;
1929insert into &lib..MPE_VALIDATIONS set
1930 tx_from=0
1931 ,base_lib="&lib"
1932 ,base_ds="MPE_TABLES"
1933 ,base_col="VAR_BUSTO"
1934 ,rule_type='SOFTSELECT_HOOK'
1935 ,rule_value="services/validations/columns_in_libds"
1936 ,rule_active=1
1937 ,tx_to='31DEC5999:23:59:59'dt;
1938insert into &lib..MPE_VALIDATIONS set
1939 tx_from=0
1940 ,base_lib="&lib"
1941 ,base_ds="MPE_TABLES"
1942 ,base_col="VAR_PROCESSED"
1943 ,rule_type='SOFTSELECT_HOOK'
1944 ,rule_value="services/validations/columns_in_libds"
1945 ,rule_active=1
1946 ,tx_to='31DEC5999:23:59:59'dt;
1947insert into &lib..MPE_VALIDATIONS set
1948 tx_from=0
1949 ,base_lib="&lib"
1950 ,base_ds="MPE_SELECTBOX"
1951 ,base_col="SELECT_LIB"
1952 ,rule_type='SOFTSELECT_HOOK'
1953 ,rule_value="services/validations/libraries_editable"
1954 ,rule_active=1
1955 ,tx_to='31DEC5999:23:59:59'dt;
1956insert into &lib..MPE_VALIDATIONS set
1957 tx_from=0
1958 ,base_lib="&lib"
1959 ,base_ds="MPE_SELECTBOX"
1960 ,base_col="SELECT_DS"
1961 ,rule_type='SOFTSELECT_HOOK'
1962 ,rule_value="services/validations/tables_editable"
1963 ,rule_active=1
1964 ,tx_to='31DEC5999:23:59:59'dt;
1965insert into &lib..MPE_VALIDATIONS set
1966 tx_from=0
1967 ,base_lib="&lib"
1968 ,base_ds="MPE_SELECTBOX"
1969 ,base_col="BASE_COLUMN"
1970 ,rule_type='SOFTSELECT_HOOK'
1971 ,rule_value="services/validations/columns_in_libds"
1972 ,rule_active=1
1973 ,tx_to='31DEC5999:23:59:59'dt;
1974insert into &lib..MPE_VALIDATIONS set
1975 tx_from=0
1976 ,base_lib="&lib"
1977 ,base_ds="MPE_ROW_LEVEL_SECURITY"
1978 ,base_col="RLS_GROUP"
1979 ,rule_type='SOFTSELECT_HOOK'
1980 ,rule_value="services/validations/sas_groups"
1981 ,rule_active=1
1982 ,tx_to='31DEC5999:23:59:59'dt;
1983insert into &lib..MPE_VALIDATIONS set
1984 tx_from=0
1985 ,base_lib="&lib"
1986 ,base_ds="MPE_ROW_LEVEL_SECURITY"
1987 ,base_col="RLS_LIBREF"
1988 ,rule_type='SOFTSELECT_HOOK'
1989 ,rule_value="services/validations/libraries_all"
1990 ,rule_active=1
1991 ,tx_to='31DEC5999:23:59:59'dt;
1992insert into &lib..MPE_VALIDATIONS set
1993 tx_from=0
1994 ,base_lib="&lib"
1995 ,base_ds="MPE_ROW_LEVEL_SECURITY"
1996 ,base_col="RLS_TABLE"
1997 ,rule_type='SOFTSELECT_HOOK'
1998 ,rule_value="services/validations/tables_all"
1999 ,rule_active=1
2000 ,tx_to='31DEC5999:23:59:59'dt;
2001insert into &lib..MPE_VALIDATIONS set
2002 tx_from=0
2003 ,base_lib="&lib"
2004 ,base_ds="MPE_ROW_LEVEL_SECURITY"
2005 ,base_col="RLS_SUBGROUP_ID"
2006 ,rule_type='MINVAL'
2007 ,rule_value='0'
2008 ,rule_active=1
2009 ,tx_to='31DEC5999:23:59:59'dt;
2010insert into &lib..MPE_VALIDATIONS set
2011 tx_from=0
2012 ,base_lib="&lib"
2013 ,base_ds="MPE_ROW_LEVEL_SECURITY"
2014 ,base_col="RLS_SUBGROUP_ID"
2015 ,rule_type='NOTNULL'
2016 ,rule_value='0'
2017 ,rule_active=1
2018 ,tx_to='31DEC5999:23:59:59'dt;
2019insert into &lib..MPE_VALIDATIONS set
2020 tx_from=0
2021 ,base_lib="&lib"
2022 ,base_ds="MPE_ROW_LEVEL_SECURITY"
2023 ,base_col="RLS_VARIABLE_NM"
2024 ,rule_type='SOFTSELECT_HOOK'
2025 ,rule_value="services/validations/columns_in_libds"
2026 ,rule_active=1
2027 ,tx_to='31DEC5999:23:59:59'dt;
2028/* test softselect on numeric var (should be ordered numerically) */
2029insert into &lib..MPE_VALIDATIONS set
2030 tx_from=0
2031 ,base_lib="&lib"
2032 ,base_ds="MPE_X_TEST"
2033 ,base_col="SOME_BESTNUM"
2034 ,rule_type='SOFTSELECT'
2035 ,rule_value="&lib..MPE_X_TEST.SOME_BESTNUM"
2036 ,rule_active=1
2037 ,tx_to='31DEC5999:23:59:59'dt;
2038/* test hard regex - SOME_CHAR must contain "the" or "data" */
2039insert into &lib..MPE_VALIDATIONS set
2040 tx_from=0
2041 ,base_lib="&lib"
2042 ,base_ds="MPE_X_TEST"
2043 ,base_col="SOME_CHAR"
2044 ,rule_type='HARDREGEX'
2045 ,rule_value='/the|data/i'
2046 ,rule_active=1
2047 ,tx_to='31DEC5999:23:59:59'dt;
2048/* test soft regex - SOME_CHAR should contain the letter "t" */
2049insert into &lib..MPE_VALIDATIONS set
2050 tx_from=0
2051 ,base_lib="&lib"
2052 ,base_ds="MPE_X_TEST"
2053 ,base_col="SOME_CHAR"
2054 ,rule_type='SOFTREGEX'
2055 ,rule_value='/t/'
2056 ,rule_active=1
2057 ,tx_to='31DEC5999:23:59:59'dt;
2058/* test soft regex - PRIMARY_KEY_FIELD should be an integer (yellow if it
2059contains a decimal point). All generated keys are integers, so no
2060warning shows until a demo user enters a decimal. */
2061insert into &lib..MPE_VALIDATIONS set
2062 tx_from=0
2063 ,base_lib="&lib"
2064 ,base_ds="MPE_X_TEST"
2065 ,base_col="PRIMARY_KEY_FIELD"
2066 ,rule_type='SOFTREGEX'
2067 ,rule_value='/^\d+$/'
2068 ,rule_active=1
2069 ,tx_to='31DEC5999:23:59:59'dt;
2070/* test hard regex - SOME_SHORTNUM must not be between 1 and 5. Generated
2071data starts at 6, so nothing is blocked until a demo user enters 1-5. */
2072insert into &lib..MPE_VALIDATIONS set
2073 tx_from=0
2074 ,base_lib="&lib"
2075 ,base_ds="MPE_X_TEST"
2076 ,base_col="SOME_SHORTNUM"
2077 ,rule_type='HARDREGEX'
2078 ,rule_value='/^(?![1-5](\.\d+)?$).*/'
2079 ,rule_active=1
2080 ,tx_to='31DEC5999:23:59:59'dt;
2081insert into &lib..MPE_VALIDATIONS set
2082 tx_from=0
2083 ,base_lib="&lib"
2084 ,base_ds="MPE_X_TEST"
2085 ,base_col="SOME_NUM"
2086 ,rule_type='HARDSELECT_HOOK'
2087 ,rule_value="services/validations/mpe_x_test.some_num"
2088 ,rule_active=1
2089 ,tx_to='31DEC5999:23:59:59'dt;
2090insert into &lib..MPE_VALIDATIONS set
2091 tx_from=0
2092 ,base_lib="&lib"
2093 ,base_ds="MPE_EXCEL_CONFIG"
2094 ,base_col="XL_ACTIVE"
2095 ,rule_type='MINVAL'
2096 ,rule_value='0'
2097 ,rule_active=1
2098 ,tx_to='31DEC5999:23:59:59'dt;
2099insert into &lib..MPE_VALIDATIONS set
2100 tx_from=0
2101 ,base_lib="&lib"
2102 ,base_ds="MPE_EXCEL_CONFIG"
2103 ,base_col="XL_ACTIVE"
2104 ,rule_type='MAXVAL'
2105 ,rule_value='1'
2106 ,rule_active=1
2107 ,tx_to='31DEC5999:23:59:59'dt;
2108insert into &lib..MPE_VALIDATIONS set
2109 tx_from=0
2110 ,base_lib="&lib"
2111 ,base_ds="MPE_XLMAP_INFO"
2112 ,base_col="XLMAP_ID"
2113 ,rule_type='SOFTSELECT'
2114 ,rule_value="&lib..MPE_XLMAP_RULES.XLMAP_ID"
2115 ,rule_active=1
2116 ,tx_to='31DEC5999:23:59:59'dt;
2117
2118
2119/**
2120 * MPE_X_TEST
2121 */
2122 insert into &lib..mpe_x_test
2123 set primary_key_field=0
2124 ,some_char='this is dummy data'
2125 ,some_dropdown='Option 1'
2126 ,some_num=42
2127 ,some_date=42
2128 ,some_datetime=42
2129 ,some_time=42
2130 ,some_shortnum=8
2131 ,some_bestnum=44;
2132 insert into &lib..mpe_x_test
2133 set primary_key_field=1
2134 ,some_char='more dummy data'
2135 ,some_dropdown='Option 2'
2136 ,some_num=42
2137 ,some_date=42
2138 ,some_datetime=42
2139 ,some_time=422
2140 ,some_shortnum=8
2141 ,some_bestnum=44;
2142 insert into &lib..mpe_x_test
2143 set primary_key_field=2
2144 ,some_char='even more dummy data'
2145 ,some_dropdown='Option 3'
2146 ,some_num=42
2147 ,some_date=42
2148 ,some_datetime=42
2149 ,some_time=142
2150 ,some_shortnum=8
2151 ,some_bestnum=44;
2152 insert into &lib..mpe_x_test
2153 set primary_key_field=3
2154 ,some_char=repeat('It was a dark and stormy night. The wind was blowing'
2155 !!' a gale! The captain said to his mate - mate, tell us a tale. And'
2156 !!' this, is the tale he told: ',3)
2157 ,some_dropdown='Option 2'
2158 ,some_num=1613.001
2159 ,some_date=423
2160 ,some_datetime=423
2161 ,some_time=44
2162 ,some_shortnum=8
2163 ,some_bestnum=44;
2164 insert into &lib..mpe_x_test
2165 set primary_key_field=4
2166 ,some_char='if you can fill the unforgiving minute'
2167 ,some_dropdown='Option 1'
2168 ,some_num=1613.001123456
2169 ,some_date=4231
2170 ,some_datetime=423123123
2171 ,some_time=412
2172 ,some_shortnum=8
2173 ,some_bestnum=44;
2174 insert into &lib..mpe_x_test
2175 set primary_key_field=5
2176 ,some_char='= testing the formula situation'
2177 ,some_dropdown='Option 1'
2178 ,some_num=42
2179 ,some_date=42
2180 ,some_datetime=42
2181 ,some_time=42
2182 ,some_shortnum=8
2183 ,some_bestnum=44;
2184 insert into &lib..mpe_x_test
2185 set primary_key_field=6
2186 ,some_char="'=the formula with leading apostrophe"
2187 ,some_dropdown='Option 1'
2188 ,some_num=42
2189 ,some_date=42
2190 ,some_datetime=42
2191 ,some_time=42
2192 ,some_shortnum=8
2193 ,some_bestnum=44;
2194%do x=10 %to 500;
2195 insert into &lib..mpe_x_test
2196 set primary_key_field=10&x
2197 ,some_char="&x bottles of beer on the wall"
2198 ,some_dropdown='Option 1'
2199 ,some_num=ranuni(0)
2200 ,some_date=round(ranuni(0)*1000,1)
2201 ,some_datetime=round(ranuni(0)*50000,1)
2202 ,some_time=round(ranuni(0)*100,1)
2203 ,some_shortnum=6+round(ranuni(0)*94,1)
2204 ,some_bestnum=round(ranuni(0)*100,1);
2205%end;
2206
2207
2208/* https://support.sas.com/resources/papers/proceedings/proceedings/sugi27/p056-27.pdf */
2209proc format library=&lib..mpe_x_catalog;
2210 value otdate
2211 .Z = 'Some Zs'
2212 .N = 'Some 9s'
2213 other = [date9.]
2214 ;
2215 invalue disc
2216 'ABC' = 0.20
2217 'DEF' = 0.25
2218 'XYZ' = 0.00
2219 other = 0.00
2220 ;
2221 invalue indate
2222 '00000000' = .Z
2223 '99999999' = .N
2224 other = [yymmdd8.]
2225 ;
2226 value age(multilabel)
2227 20 - 29 = '20 - 29'
2228 30 - 39 = '30 - 39'
2229 40 - 49 = '40 - 49'
2230 50 - 59 = '50 - 59'
2231 60 - high = '60 +++'
2232 20 - 35 = '20 - 35'
2233 36 - 55 = '36 - 55'
2234 55 - high = '55 +++'
2235 ;
2236/* https://libguides.library.kent.edu/SAS/UserDefinedFormats */
2237 VALUE $GENDERLABEL
2238 "M" = "Male"
2239 "F" = "Female"
2240 ;
2241 VALUE LIKERT_SEVEN
2242 1 = "Strongly Disagree"
2243 2 = "Disagree"
2244 3 = "Slightly Disagree"
2245 4 = "Neither Agree nor Disagree"
2246 5 = "Slightly Agree"
2247 6 = "Agree"
2248 7 = "Strongly Agree"
2249 ;
2250 VALUE LIKERT7_ELEVEN
2251 1,2,3 = "Disagree"
2252 4 = "Neither Agree nor Disagree"
2253 5,6,7 = "Agree"
2254 ;
2255 VALUE LIKERT7_SISTERS
2256 1-3 = "Disagree"
2257 4 = "Neither Agree nor Disagree"
2258 5-7 = "Agree"
2259 ;
2260 VALUE INCOME
2261 LOW -< 20000 = "Low"
2262 20000 -< 60000 = "Middle"
2263 60000 - HIGH = "High"
2264 ;
2265 VALUE RACE
2266 1 = "White"
2267 2 = "Black"
2268 OTHER = "Other"
2269 ;
2270 VALUE GENDERCODE
2271 0 = 'Male'
2272 1 = 'Female';
2273 VALUE ATHLETECODE
2274 0 = 'Non-athlete'
2275 1 = 'Athlete';
2276 VALUE SMOKINGCODE
2277 0 = 'Nonsmoker'
2278 1 = 'Past smoker'
2279 2 = 'Current smoker';
2280/* https://documentation.sas.com/doc/en/pgmsascdc/v_017/proc/p1upn25lbfo6mkn1wncu4dyh9q91.htm */
2281 value $state
2282 'Delaware'='DE'
2283 'Florida'='FL'
2284 'Ohio'='OH';
2285 value MYfmt
2286 /* Format dates prior to 31DEC2011 using only a year. */
2287 low-'31DEC2011'd=[year4.]
2288
2289 /* Format 2012 dates using the month and year. */
2290 '01jan2012'd-'31DEC12'd=[monyy7.]
2291
2292 /* Format dates 01JAN2013 and beyond using the day, month, and year. */
2293 '01JAN2013'd-high=[date9.]
2294
2295 /* Catch missing values. */
2296 other='n/a';
2297 value newfmt .='N/A' other=[12.1];
2298/* https://www.lexjansen.com/nesug/nesug08/cc/cc14.pdf */
2299 value $genderml (multilabel)
2300 '1'='Male'
2301 '2'='Female'
2302 '1','2',' '='Total people';
2303 value agemla (multilabel)
2304 1-4='Preschool'
2305 1-18='Children'
2306 19-120='Adults';
2307 value agemlb (multilabel)
2308 19-120='Adults'
2309 1-18='Children'
2310 1-4='Preschool';
2311 value agemlc (multilabel notsorted)
2312 19-120='Adults'
2313 1-18='Children'
2314 1-4='Preschool';
2315%mend mpe_makedata;