getcolvals.sas File Reference

Retrieves column info to enable population of dropdowns. More...

Go to the source code of this file.

Detailed Description

An optional filterquery may be provided, if so then it is validated and then used to filter the subsequent results.

Service Inputs

IWANT

The STARTROW and ROWS variables are used to fetch additional values beyond the initial default (4000).

libds:$19.	col:$9.	STARTROW:8.	ROWS:8.
DC258467.MPE_X_TEST	SOME_TIME	4001	1000

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

VALS

The type of this column actually depends on the underlying column type, so it can change

FORMATTED	UNFORMATTED
$44.00	44

META

COLUMN:$32.	SASFORMAT:$32.	STARTROW:8.	ROWS:8.
COL_NAME	DOLLAR8.2	4001	1000

SAS Macros

• mf_existds.sas
• mf_getvalue.sas
• mf_verifymacvars.sas
• dc_assignlib.sas
• mf_getvarformat.sas
• mp_abort.sas
• mp_cntlout.sas
• mp_filtercheck.sas
• mp_filtergenerate.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 getcolvals.sas.