title: Stata Data cleaning
body: <p>I need some help with Stata data transformation.</p>
  <p>I have a survey, where the user can answer with &quot;no response&quot; which has been coded to integer 98. The variables can be of different data types. I need to get the number of &quot;no response&quot;/98 by a user into a separate variable.</p>
  <p>I attached the dataset sample:</p>
  <pre><code>UserN   Q1    Q2       Q3       Q4    Q5          Q6      NewCreatedColumn
              
  User1    11 &quot;male&quot;   &quot;12:55pm&quot;  98  &quot;Answer1&quot;   &quot;other&quot;     1
  User2    98 &quot;female&quot; &quot;1:00am&quot;   98  &quot;AnswerX&quot;   &quot;Batman&quot;    2
  User3    16 &quot;male&quot;   &quot;1:00am&quot;   34  &quot;other&quot;     &quot;superman&quot;  0
  User4    98 &quot;female&quot; &quot;1:00am&quot;   98  &quot;other&quot;      &quot;Dog&quot;      2
  User5    66 &quot;male&quot;   &quot;1:00am&quot;   98  &quot;Life&quot;       &quot;Cat&quot;      1
  </code></pre>
  <p>This would have been fairly easy in python, with each user in the dataframe is a list and you can scan for integer 98 in the list.</p>
  <p>Is there an equivalent in Stata?</p>
  <p><a href="https://i.stack.imgur.com/uDRnF.png" rel="nofollow noreferrer">Sample Data</a></p>