25%mddl_derivedvars(libds=work.dvcfg)
29 set libref='WORK',dsn='CLASS',var_nm='band',var_deps='AGE'
30 ,var_type=
'C',var_len=8,var_fmt='',active=1
31 ,var_logic=
"ifc(AGE>13,'TEEN','JUNIOR')";
33 set libref='WORK',dsn='CLASS',var_nm='band_age',var_deps='BAND AGE'
34 ,var_type=
'C',var_len=16,var_fmt='',active=1
35 ,var_logic=
"cats(BAND,'-',AGE)";
37 set libref='WORK',dsn='CLASS',var_nm='double_age',var_deps='AGE'
38 ,var_type=
'N',var_len=8,var_fmt='',active=1
42 set libref='WORK',dsn='CLASS',var_nm='band_label',var_deps='BAND SEX'
43 ,var_type=
'C',var_len=32,var_fmt='',active=1
44 ,var_logic=
"cats(BAND,'-',SEX)";
47 set libref='WORK',dsn='CLASS',var_nm='ignored',var_deps=''
48 ,var_type=
'C',var_len=8,var_fmt='',active=0
54%mp_assertscope(SNAPSHOT)
63 reserved=%str(_____DELETE__THIS__RECORD_____ TX_FROM TX_TO)
67%mp_assertdsobs(work.dvnames,
68 desc=Only the active variables are returned,
70 outds=work.test_results
73%mp_assertcols(work.vw_dv,
74 desc=The view carries the derived columns,
75 cols=BAND BAND_AGE DOUBLE_AGE BAND_LABEL,
77 outds=work.test_results
81 iftrue=(%mf_existvar(work.vw_dv,IGNORED)=0),
82 desc=The inactive variable is not in the view,
83 outds=work.test_results
90 if band_age ne cats(band,
'-',AGE) then output;
91 if double_age ne AGE*2 then output;
92 if band_label ne cats(band,
'-',SEX) then output;
95%mp_assertdsobs(work.chk,
96 desc=Derived values and chained values are correct,
98 outds=work.test_results
106%mp_assertdsobs(work.chk2,
107 desc=A derived variable can be filtered on,
109 outds=work.test_results
113proc contents noprint data=work.vw_dv out=work.vcols(keep=name label);
118 where name='BAND' and label=:'BAND=ifc(AGE>13';
121%mp_assertdsobs(work.chklab,
122 desc=The label carries the variable name and the expression,
124 outds=work.test_results
128 iftrue=(
"%mf_existds(libds=work.vw_dv)"=
"1"),
129 desc=The view was built,
130 outds=work.test_results
136 infile derref truncover;
142 set work.stmts end=eof;
143 retain band_seq bandage_seq;
144 if prxmatch('/^BAND\s*=/',strip(line)) and missing(band_seq) then band_seq=seq;
145 if prxmatch('/^BAND_AGE\s*=/',strip(line)) and missing(bandage_seq)
146 then bandage_seq=seq;
148 if missing(band_seq) or missing(bandage_seq) or band_seq>=bandage_seq
152%mp_assertdsobs(work.chkord,
153 desc=BAND is assigned before BAND_AGE whatever order the rows were loaded,
155 outds=work.test_results
159%mddl_derivedvars(libds=work.dvcfg_label)
162insert into work.dvcfg_label
163 set libref='WORK',dsn='CLASS',var_nm='band',var_deps='AGE'
164 ,var_type=
'C',var_len=8,var_fmt='',var_label='Age band'
165 ,var_logic=
"ifc(AGE>13,'TEEN','JUNIOR')",active=1;
166insert into work.dvcfg_label
167 set libref='WORK',dsn='CLASS',var_nm='double_age',var_deps='AGE'
168 ,var_type=
'N',var_len=8,var_fmt='',var_label=''
169 ,var_logic='AGE * 2',active=1;
174 control=work.dvcfg_label,
176 outview=work.vw_label
182 infile derref7 truncover;
187 set work.stmts7 end=eof;
188 retain found_custom found_default;
189 if index(line,
"label='Age band'")>0 then found_custom=1;
190 if index(line,
"label='DOUBLE_AGE=AGE * 2'")>0 then found_default=1;
192 if not found_custom or not found_default then output;
195%mp_assertdsobs(work.chklbl,
196 desc=VAR_LABEL is used when set and defaults when blank,
198 outds=work.test_results
204%mddl_derivedvars(libds=work.derived_vars)
207insert into work.derived_vars
208 set libref='WORK',dsn='CLASS',var_nm='band',var_deps='AGE'
209 ,var_type=
'C',var_len=8,var_fmt='',active=1
210 ,var_logic=
"ifc(AGE>13,'TEEN','JUNIOR')";
215 control=work.derived_vars,
217 outview=work.vw_default
221 iftrue=(0 < %mf_existvar(work.vw_default,BAND)),
222 desc=The default outvars does not overwrite the control table,
223 outds=work.test_results
227 iftrue=(%mf_nobs(work.derived_vars)=1),
228 desc=The control table survives the default outvars name,
229 outds=work.test_results
236 control=work.derived_vars,
237 where=%str(var_nm ne
"NOPE"),
239 outvars=work.dvnames11,
240 outview=work.vw_wherequote
243%mp_assertdsobs(work.dvnames11,
244 desc=A filter containing quotes is applied,
246 outds=work.test_results
250 iftrue=(0 < %mf_existvar(work.vw_wherequote,BAND)),
251 desc=The view is still built when the filter contains quotes,
252 outds=work.test_results
256%mddl_derivedvars(libds=work.dvcfg_empty)
260 control=work.dvcfg_empty,
262 outview=work.vw_empty,
263 outvars=work.dvnames3
266%mp_assertdsobs(work.dvnames3,
267 desc=No rows in the control table means no variables,
269 outds=work.test_results
273 iftrue=(%mf_existds(libds=work.vw_empty)=0),
274 desc=No view is built when there is nothing to derive,
275 outds=work.test_results
281 control=work.doesnotexist,
283 outvars=work.dvnames4
286%mp_assertdsobs(work.dvnames4,
287 desc=A missing control table yields no variables,
289 outds=work.test_results
295%mddl_derivedvars(libds=work.dvcfg_diamond)
298insert into work.dvcfg_diamond
299 set libref='WORK',dsn='CLASS',var_nm='v5',var_deps='SEX V4'
300 ,var_type=
'C',var_len=40,var_fmt='',var_logic=
"cats(SEX,'-',put(V4,best12.))"
302insert into work.dvcfg_diamond
303 set libref='WORK',dsn='CLASS',var_nm='v4',var_deps='V2 V3'
304 ,var_type=
'N',var_len=8,var_fmt='',var_logic='V2 + V3',active=1;
305insert into work.dvcfg_diamond
306 set libref='WORK',dsn='CLASS',var_nm='v3',var_deps='V1'
307 ,var_type=
'N',var_len=8,var_fmt='',var_logic='V1 + 1',active=1;
308insert into work.dvcfg_diamond
309 set libref='WORK',dsn='CLASS',var_nm='v2',var_deps='V1'
310 ,var_type=
'N',var_len=8,var_fmt='',var_logic='V1 * 2',active=1;
311insert into work.dvcfg_diamond
312 set libref='WORK',dsn='CLASS',var_nm='v1',var_deps='AGE'
313 ,var_type=
'N',var_len=8,var_fmt='',var_logic='AGE + 0',active=1;
318 control=work.dvcfg_diamond,
320 outview=work.vw_diamond
323%mp_assertcols(work.vw_diamond,
324 desc=The diamond graph is fully materialised,
327 outds=work.test_results
332 if v1 ne age then output;
333 if v2 ne age*2 then output;
334 if v3 ne age+1 then output;
335 if v4 ne age*3+1 then output;
336 if v5 ne cats(sex,
'-',put(age*3+1,best12.)) then output;
339%mp_assertdsobs(work.chkdiamond,
340 desc=Every variable in the diamond graph resolves to the right value,
342 outds=work.test_results
347 infile derref8 truncover;
351 if prxmatch('/^V\d+\s*=/',strip(line)) then nm=scan(strip(line),1,
'=');
356 set work.chkorder end=eof;
357 retain s1 s2 s3 s4 s5;
358 if nm='V1' then s1=seq;
359 if nm='V2' then s2=seq;
360 if nm='V3' then s3=seq;
361 if nm='V4' then s4=seq;
362 if nm='V5' then s5=seq;
364 if missing(s1) or missing(s2) or missing(s3) or missing(s4) or missing(s5)
366 else if s1 ge min(s2,s3) then output;
367 else if max(s2,s3) ge s4 then output;
368 else if s4 ge s5 then output;
371%mp_assertdsobs(work.chkorder2,
372 desc=The diamond graph is assigned in dependency order,
374 outds=work.test_results
379%mddl_derivedvars(libds=work.dvcfg_long)
383 logic=cats(
"ifc(AGE>13,'",repeat(
'a',300),
"','short')");
387insert into work.dvcfg_long
388 (libref,dsn,var_nm,var_deps,var_type,var_len,var_fmt,var_logic,active)
389 select 'WORK
','CLASS
','LONG_LABEL
','AGE
','C',400,'',logic,1
395 control=work.dvcfg_long,
401 infile derref9 truncover;
403 if index(line,
"label='")>0 and mod(count(line,
"'"),2) ne 0 then output;
406%mp_assertdsobs(work.chkquotes,
407 desc=A truncated label keeps an even quote count,
409 outds=work.test_results
413 iftrue=(%mf_existds(libds=work.vw_long)=1),
414 desc=A label longer than the limit still builds the view,
415 outds=work.test_results
424%mddl_derivedvars(libds=work.dvcfg_multi)
427insert into work.dvcfg_multi
428 set libref='WORK',dsn='CLASS',var_nm='scaled',var_deps='AGE'
429 ,var_type=
'N',var_len=8,var_fmt='',var_logic='AGE + 100',active=1;
430insert into work.dvcfg_multi
431 set libref='WORK',dsn='CLASS2',var_nm='scaled',var_deps='AGE'
432 ,var_type=
'N',var_len=8,var_fmt='dollar12.2',var_logic='AGE + 200',active=1;
437 control=work.dvcfg_multi,
439 outview=work.vw_multi1
444 control=work.dvcfg_multi,
446 outview=work.vw_multi2
450 merge work.vw_multi1(keep=name age scaled rename=(scaled=scaled1))
451 work.vw_multi2(keep=name age scaled rename=(scaled=scaled2));
453 if scaled1 ne age + 100 then output;
454 if scaled2 ne age + 200 then output;
457%mp_assertdsobs(work.chkmulti,
458 desc=The same variable name means different things per table,
460 outds=work.test_results
466 infile derref10 truncover;
468 if index(line,'format=DOLLAR12.2')>0 then output;
471%mp_assertdsobs(work.chkfmt,
472 desc=A configured format is applied,
474 outds=work.test_results
487 logic=
"dosubl(cats('data _null_',byte(59),'data work.pwn',byte(59)
491%mddl_derivedvars(libds=work.dvcfg_inject)
494insert into work.dvcfg_inject
495 (libref,dsn,var_nm,var_deps,var_type,var_len,var_fmt,var_logic,active)
496 select 'WORK
','CLASS
','pwn
','','N',8,'',logic,1 from work.payload;
501 control=work.dvcfg_inject,
504 outvars=work.dvn_inj,
506 errds=work.dv_inj_err
509%mp_assertdsobs(work.dv_inj_err,
510 desc=A DOSUBL payload is refused even though it carries no semicolon,
512 outds=work.test_results
516 iftrue=(%mf_existds(libds=work.vw_inj)=0),
517 desc=No view is built for a refused payload,
518 outds=work.test_results
524 logic=
"fread(fopen('/etc/hostname'))";
527%mddl_derivedvars(libds=work.dvcfg_fread)
530insert into work.dvcfg_fread
531 (libref,dsn,var_nm,var_deps,var_type,var_len,var_fmt,var_logic,active)
532 select 'WORK
','CLASS
','leak
','','C',200,'',logic,1 from work.payload2;
537 control=work.dvcfg_fread,
545%mp_assertdsobs(work.dv_fr_err,
546 desc=A file read payload is refused,
548 outds=work.test_results
553 logic=
"symputx('syscc',0)";
556%mddl_derivedvars(libds=work.dvcfg_symput)
559insert into work.dvcfg_symput
560 (libref,dsn,var_nm,var_deps,var_type,var_len,var_fmt,var_logic,active)
561 select 'WORK
','CLASS
','sneaky
','','N',8,'',logic,1 from work.payload3;
566 control=work.dvcfg_symput,
574%mp_assertdsobs(work.dv_sp_err,
575 desc=A macro symbol table write is refused,
577 outds=work.test_results
586%mddl_derivedvars(libds=work.dvcfg_sleep)
589insert into work.dvcfg_sleep
590 (libref,dsn,var_nm,var_deps,var_type,var_len,var_fmt,var_logic,active)
591select 'WORK
','CLASS
','slow
','','N',8,'',logic,1 from work.payload4;
596 control=work.dvcfg_sleep,
604%mp_assertdsobs(work.dv_sl_err,
605 desc=A per row delay is refused,
607 outds=work.test_results
613 logic=
"ifc(SEX='DOSUBL(','Y','N')";
616%mddl_derivedvars(libds=work.dvcfg_literal)
619insert into work.dvcfg_literal
620 (libref,dsn,var_nm,var_deps,var_type,var_len,var_fmt,var_logic,active)
621 select 'WORK
','CLASS
','literal_ok
','SEX
','C',1,'',logic,1 from work.payload5;
626 control=work.dvcfg_literal,
629 outvars=work.dvn_lit,
631 errds=work.dv_lit_err
634%mp_assertdsobs(work.dv_lit_err,
635 desc=A refused word inside a quoted literal is allowed,
637 outds=work.test_results
641 iftrue=(0 < %mf_existvar(work.vw_lit,LITERAL_OK)),
642 desc=The literal control still builds its view,
643 outds=work.test_results
649%mddl_derivedvars(libds=work.dvcfg_multi)
652insert into work.dvcfg_multi
653 set libref='WORK',dsn='CLASS',var_nm='aaa',var_deps=''
654 ,var_type=
'N',var_len=8,var_fmt='',var_logic='zzz+1',active=1;
655insert into work.dvcfg_multi
656 set libref='WORK',dsn='CLASS',var_nm='zzz',var_deps='AGE'
657 ,var_type=
'X',var_len=8,var_fmt='',var_logic='AGE',active=1;
662 control=work.dvcfg_multi,
664 outview=work.vw_multi,
665 outvars=work.dvn_multi,
667 errds=work.dv_multi_err
670%mp_assertdsobs(work.dv_multi_err,
671 desc=abort NO reports every broken rule not just the first,
673 outds=work.test_results
677 iftrue=(%mf_existds(libds=work.vw_multi)=0),
678 desc=abort NO builds no view when any rule fails,
679 outds=work.test_results
682%mp_assertscope(COMPARE,ignorelist=_SASJS_WEBOUT_HEADERS,outds=work.test_results)