Desktop productivity for business analysts and programmers

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

Reply
N/A
Posts: 0

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

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.
Trusted Advisor
Posts: 2,114

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

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.
Ask a Question
Discussion stats
  • 1 reply
  • 169 views
  • 0 likes
  • 2 in conversation