Dear all
I have a database of around 50 variables and 200 observations. I would like to replace with the value 0, in those observations that says in the all variables the word 'quantity'.
For example, from the following database, I would like to replace the word quantity with the value 0 in variable 1 and 2.
Observation Var 1 Var 2
1 400 200
2 quantity 800
3 300 quantity
4 quantity 1000
The question is, what command can I use to do it in the 50 variables that I have and in the 200 observations, in a simple way?
Thank you very much!