我将公司基本数据与我经过处理后的违规公司的0-1变量数据进行合并,而没有匹配的部分为没有违规的显示为.,如何能将其中的.转变为0
Example generated by -dataex-. To install: ssc install dataex
clear
input str6 symbol float(year violation1)
"600113" 2004 0
"600113" 2005 0
"600113" 2006 0
"600113" 2007 0
"600113" 2008 0
"600113" 2009 0
"600113" 2010 0
"600113" 2011 0
"600113" 2012 0
"600113" 2013 0
"600113" 2014 0
"600113" 2015 0
"600113" 2016 0
"600113" 2017 0
"600113" 2018 1
"600114" 2004 .
"600114" 2005 .
"600114" 2006 .
"600114" 2007 .
"600114" 2008 .
"600114" 2009 .
"600114" 2010 .
"600114" 2011 .
"600114" 2012 .
"600114" 2013 .
"600114" 2014 .
"600114" 2015 .
"600114" 2016 .
"600114" 2017 .
"600114" 2018 .
"600115" 2004 .
"600115" 2005 .
"600115" 2006 .
"600115" 2007 .
"600115" 2008 .
"600115" 2009 .
"600115" 2010 .
"600115" 2011 .
"600115" 2012 .
"600115" 2013 .
"600115" 2014 .
"600115" 2015 .
"600115" 2016 .
"600115" 2017 .
"600115" 2018 .
end