validatefilter.sas File Reference

Validates a filter clause before it gets hashified, returns the RK. More...

Go to the source code of this file.

Detailed Description

Used to generate a FILTER_RK from an input query dataset. Raw values are stored in dc.mpe_filtersource and the meta values are stored in dc.mpe_filteranytable

Service Inputs

IWANT

FILTER_TABLE:$41.
DC258467.MPE_X_TEST

FILTERQUERY

GROUP_LOGIC:$3	SUBGROUP_LOGIC:$3	SUBGROUP_ID:8.	VARIABLE_NM:$32	OPERATOR_NM:$10	RAW_VALUE:$32767
AND	AND	1	SOME_BESTNUM	>	1
AND	AND	1	SOME_TIME	=	77333

Service Outputs

result

• FILTER_HASH
• FILTER_RK
• FILTER_TABLE

SAS Macros

• dc_assignlib.sas
• mf_getvalue.sas
• mp_filterstore.sas
• removecolsfromwork.sas

Version

9.2

Author

4GL Apps Ltd

Copyright

4GL Apps Ltd. This code may only be used within Data Controller and may not be re-distributed or re-sold without the express permission of 4GL Apps Ltd.

Definition in file validatefilter.sas.