function to find out if a value exist in a variable or not

[deleted_user]

which function in sas 9.1 can be used to find out if a value exist in a variable of a dataset or not?
for example:
dataset:
rollno name
1 anuj
2 ram
3 kamal
i need to check if 'ram' exist in variable name or not.

[Doc_Duke]

There isn't a single function that does it. You will need to do some data step coding.

The INDEX function can be used in a DATA step to find out if a specific string exists in a character variable. You can set up an ARRAY to include all the character variables,
ARRAY CharVar {*} _CHARACTER_;
(I think that is the syntax.), and then use a DO loop to look at all the character variables.