Replace ZEROS

[Pepe SK]

How to replace empty cells and Infinity cells with zero in the entire dataset at once? Well thank you.

[Carlo Lazzaro]

Pepe:
welcome to this forum.
If your data are in numeric format (as far as empty cells are concerned; I do not know how Stata codes -Infinity- in numerical format):

replace yourvar=0 if yourvar==.

If your variable is in -string- format:

. replace yourvar="0" if yourvar=="Infinity" | yourvar=="."

. destring yourvar, g(num_yourvar)
yourvar: all characters numeric; num_yourvar generated as byte

. list

     +--------------------+
     | yourvar   num_yo~r |
     |--------------------|
  1. |       0          0 |
  2. |       0          0 |
     +--------------------+

.

See also -foreach-.

[Nick Cox]

See also

help mvencode