https://communities.sas.com/t5/SAS-Enterprise-Guide/function-to-find-out-if-a-value-exist-in-a-variable-or-not/m-p/21484#M3475 There isn't a single function that does it. You will need to do some data step coding.<BR /> <BR /> 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,<BR /> ARRAY CharVar {*} _CHARACTER_;<BR /> (I think that is the syntax.), and then use a DO loop to look at all the character variables. Tue, 21 Apr 2009 14:20:42 GMT Doc_Duke 2009-04-21T14:20:42Z https://communities.sas.com/t5/SAS-Enterprise-Guide/function-to-find-out-if-a-value-exist-in-a-variable-or-not/m-p/21483#M3474 which function in sas 9.1 can be used to find out if a value exist in a variable of a dataset or not?<BR /> for example:<BR /> dataset:<BR /> rollno name <BR /> 1 anuj<BR /> 2 ram<BR /> 3 kamal<BR /> i need to check if 'ram' exist in variable name or not. Tue, 21 Apr 2009 13:39:57 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/function-to-find-out-if-a-value-exist-in-a-variable-or-not/m-p/21483#M3474 deleted_user 2009-04-21T13:39:57Z https://communities.sas.com/t5/SAS-Enterprise-Guide/function-to-find-out-if-a-value-exist-in-a-variable-or-not/m-p/21484#M3475 There isn't a single function that does it. You will need to do some data step coding.<BR /> <BR /> 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,<BR /> ARRAY CharVar {*} _CHARACTER_;<BR /> (I think that is the syntax.), and then use a DO loop to look at all the character variables. Tue, 21 Apr 2009 14:20:42 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/function-to-find-out-if-a-value-exist-in-a-variable-or-not/m-p/21484#M3475 Doc_Duke 2009-04-21T14:20:42Z