.-
 help for ^findval^         Stas Kolenikov, skolenik@@recep.glasnet.ru
.-


  Find a specific value
  ---------------------

  ^findval^ value [varlist] [^if^ exp] [^in^ range],
      [^sub^str ^gen^erate^(^newvarname^)^]


  Description
  -----------

^findval^ finds, lists and stores in ^r(vars)^ the variables that take
the specified value in the given range or condition. If no varlist
specified, all variables are included into search. ^findval^ can also deal
with string values -- take care, as you might forget the value as the
first argument, and ^findval^ would then search for the string coinciding
with the first variable in your list...


  Options
  -------

^substr^ specifies that value be considered as a substring rather than
        the exact match; only applicable to string values.

^generate^ creates a 0/1 variable set to one if the match is found in
        the observation, and missing if the ^if^ or ^in^ conditions are
        not satisfied.


  Examples
  --------

 . ^use auto^
 (1978 Automobile Data)

 . ^findval 100^
 The value of ^100^ is never found.

 . ^findval 5^
 The value of ^5^ is found in variables:  ^rep78 hdroom trunk^

 . ^findval 5, gen(match5)^
 The value of ^5^ is found in variables:  ^rep78 hdroom trunk^

 . ^findval 5, gen(match5f), if foreign^
 The value of ^5^ is found in variables:  ^rep78 trunk^

 . ^li make `r(vars)'  if match5f & match5f<.^

     make                   rep78     trunk 
 53. Audi 5000                  5        15  
 57. Datsun 210                 5         8  
 61. Honda Accord               5        10  
 62. Honda Civic                4         5  
 66. Subaru                     5        11  
 67. Toyota Celica              5        14  
 68. Toyota Corolla             5         9  
 69. Toyota Corona              5        11  
 71. VW Diesel                  5        15  
 74. Volvo 260                  5        14  

Mind the use of quotes for ^r(vars)^ here! The returned value is a local
macro, so you should put it in quotes to get anything from it.

 . ^sum match*^

 Variable |     Obs        Mean   Std. Dev.       Min        Max
 ---------+-----------------------------------------------------
   match5 |      74    .1756757   .3831416          0          1
  match5f |      22    .4545455   .5096472          0          1

 . ^findval Ford^
 The value of ^Ford^ is never found.

 . ^findval Ford, sub^
 The value of ^Ford^ is found in variables:  ^make^


  Returned values
  ---------------

^r(vars)^ the list of the variables containing the specified value;
        not defined if none found.
^r(value)^ the number or the string searched for.


  See also
  --------

Online: @lookfor@


  Author
  ------

Stas Kolenikov, skolenik@@recep.glasnet.ru