mpe_validatefilter.sas File Reference

Validates a filter clause and updates the source tables. 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

Input data format:

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

Parameters

[in]	libds=	The target dataset to be filtered (lib should be assigned)
[in]	queryds=	The input query dataset to be validated
[in]	dclib=	The control library for Data Controller
[out]	outresult=	The result table with the FILTER_RK
[out]	outquery=	The original query, taken as extract after table load

SAS Macros

• bitemporal_dataloader.sas
• mf_getvalue.sas
• mf_nobs.sas
• mp_abort.sas
• mp_filtercheck.sas
• mp_hashdataset.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 mpe_validatefilter.sas.