mpe_filtermaster.sas File Reference

dynamic where clause creation More...

Go to the source code of this file.

Detailed Description

Generates a where clause based on the following inputs:

• The filter_RK (if provided)
• The mode (if EDIT then filter for current records)
• The user permissions (Row Level Security)

This macro should be used whenever surfacing data to the user. Note that it is not possible to include filerefs directly in a proc sql where clause. The workaround is to use a data step view.

Note - DCLIB should be assigned.

Parameters

[in]	mode	The mode. If EDIT, then current rows are returned. Valid Values: EDIT VIEW DLOAD - used in getrawdata ULOAD - used by stagedata.sas to prevent restricted rows being submitted
[in]	libds	The target libref.dataset to which the filter will apply.
[in]	filter_rk=	(-1) The filter_rk, if available
[in]	dclib=	The libref of the DC control tables
[out]	outref=	The output fileref to create (containing the filter)
[out]	outds=	(work.query) The query dataset (if filter_rk supplied)

SAS Macros

• mf_fmtdttm.sas
• mf_getuser.sas
• mf_getuniquefileref.sas
• mf_getuniquename.sas
• mf_nobs.sas
• mp_abort.sas
• mp_filtergenerate.sas
• mpe_getgroups.sas

Version

9.3

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_filtermaster.sas.