15length name $8 sex $1 age height weight 8;
17input Name:$char. Sex :$char. Age Height Weight;
43 infile datalines4 dsd;
44 input GROUP_LOGIC:$3. SUBGROUP_LOGIC:$3. SUBGROUP_ID:8. VARIABLE_NM:$32.
45 OPERATOR_NM:$10. RAW_VALUE:$4000.;
49AND,OR,2,Name,NOT IN,
"('Jane','Janet')"
50AND,OR,2,Weight,>=,84.6
55%mp_filtergenerate(work.inds,outref=myfilter)
57%mp_assertscope(SNAPSHOT)
58%mp_filtervalidate(myfilter,work.class,outds=work.results,abort=NO)
59%mp_assertscope(COMPARE)
61%mp_assertdsobs(work.results,
64 outds=work.test_results
69 infile datalines4 dsd;
70 input GROUP_LOGIC:$3. SUBGROUP_LOGIC:$3. SUBGROUP_ID:8. VARIABLE_NM:$32.
71 OPERATOR_NM:$10. RAW_VALUE:$4000.;
75%mp_filtergenerate(work.inds,outref=myfilter)
76%mp_filtervalidate(myfilter,work.class,outds=work.results,abort=NO)
77%mp_assertdsobs(work.results,
80 outds=work.test_results
93 infile datalines4 dsd;
94 input GROUP_LOGIC:$3. SUBGROUP_LOGIC:$3. SUBGROUP_ID:8. VARIABLE_NM:$32.
95 OPERATOR_NM:$10. RAW_VALUE:$4000.;
97AND,AND,1,dt,=,
"'01DEC2021'd"
101%mp_filtergenerate(work.inds,outref=myfilter)
102%mp_filtervalidate(myfilter,work.dates,outds=work.results,abort=NO)
104%mp_assertdsobs(work.results,
105 desc=Date literal against a numeric date column,
107 outds=work.test_results
112 infile datalines4 dsd;
113 input GROUP_LOGIC:$3. SUBGROUP_LOGIC:$3. SUBGROUP_ID:8. VARIABLE_NM:$32.
114 OPERATOR_NM:$10. RAW_VALUE:$4000.;
119%mp_filtergenerate(work.inds,outref=myfilter)
120%mp_filtervalidate(myfilter,work.class,outds=work.results,abort=NO)
125 if REASON_CD=:'VALIDATION_ERROR' then call symputx('test3',1);
131 desc=Checking
char var could not receive num val,
132 outds=work.test_results
137 infile datalines4 dsd;
138 input GROUP_LOGIC:$3. SUBGROUP_LOGIC:$3. SUBGROUP_ID:8. VARIABLE_NM:$32.
139 OPERATOR_NM:$10. RAW_VALUE:$4000.;
141AND,AND,1,age,NE,
"'M'"
144%mp_filtergenerate(work.inds,outref=myfilter)
145%mp_filtervalidate(myfilter,work.class,outds=work.results,abort=NO)
150 if REASON_CD=:'VALIDATION_ERROR' then call symputx('test4',1);
156 desc=Checking num var could not receive
char val,
157 outds=work.test_results