mf_getvalue.sas File Reference

Retrieves a value from a dataset. Returned value is fetched from the 'fetchobs=' record (row 1 by default), after applying the optional filter. More...

Go to the source code of this file.

Detailed Description

Be sure to quote() your where clause. Example usage:

%put %mf_getvalue(sashelp.class,name,filter=%quote(age=15));
%put %mf_getvalue(sashelp.class,name);

SAS Macros

• mf_getattrn.sas

Related Macros

• mp_setkeyvalue.sas

Parameters

[in]	libds	dataset to query
[in]	variable	the variable which contains the value to return.
[in]	filter=	(1) contents of where clause
[in]	fetchobs=	(1) observation to fetch. NB: Filter applies first.

Version

9.2

Author

Allan Bowe

Definition in file mf_getvalue.sas.