Functions and CALL Routines |
Returns the value of a SAS data set numeric variable.
GETVARN(data-set-id,var-num)
|
-
data-set-id
-
is a numeric constant, variable, or expression
that specifies the data set identifier that the OPEN function returns.
-
var-num
-
is a numeric constant, variable, or expression
that specifies the number of the variable in the Data Set Data
Vector (DDV).
Tip: |
You can obtain this value
by using the VARNUM function. |
Tip: |
This value is listed next
to the variable when you use the CONTENTS procedure. |
Use VARNUM to obtain the number of a variable
in a SAS data set. You can nest VARNUM or you can assign it to a variable
that can then be passed as the second argument, as shown in the "Examples"
section. GETVARN reads the value of a numeric variable from the current observation
in the Data Set Data Vector (DDV) into a macro variable or DATA step variable.
-
This example obtains the entire tenth observation
from a SAS data set. The data set must have been previously opened using
OPEN. The data set identifier value for the open data set is stored in the
variable MYDATAID. This example nests VARNUM, and reads in the value of the
numeric variable PRICE from the tenth observation of an open SAS data set.
%let rc=%sysfunc(fetchobs(&mydataid,10));
%let price=%sysfunc(getvarn(&mydataid,
%sysfunc(varnum
(&mydataid,price))));
-
This example assigns VARNUM to a variable that
can then be passed as the second argument. This example fetches data from
observation 10.
%let pricenum=%sysfunc(varnum
(&mydataid,price));
%let rc=%sysfunc(fetchobs(&mydataid,10));
%let price=%sysfunc(getvarn
(&mydataid,&pricenum));
Copyright © 2011 by SAS Institute Inc., Cary, NC, USA. All rights reserved.