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

Version
9.2
Author
4GL Apps Ltd.

Definition in file getcolvals.sas.