Stata:暂元拆分

变量过多（过长）时暂元的分拆

use data_done,clear

local v1 "Premium_Pre_Bid_1Day Premium_Pre_Bid_1Week  Premium_Pre_Bid_4Weeks Deal_Value" 

local v2 "Deal_Enterprise_Value_to_Sales Deal_Enterprise_Value_to_EBITDA Deal_Enterprise_Value_to_EBIT  enterprise_value_announce enterprise_value_effective"

local v3 "Initial_Offer_Price  Acquired acquiror_stock_price_one_day acquiror_stock_price_on_day "

local v4 "Deal_Equity_Value_to_Net_Income equity_value_announce equity_value_effective "

local v5 "target_stock_price_onday target_stock_price_oneday Share_Price_Paid_by_Acquiror Held Sought" 

local v6 "Rank_Value_Credit af_rank_value_credit al_rank_value_credit tf_rank_value_credit tl_rank_value_credit"

local vv "`v1' `v2' `v3' `v4' `v5' `v6'"
foreach v of local vv{
#去掉特殊字符
replace `v'=subinstr(`v',",","",.)
cap drop  _`v'
gen _`v'=real(`v')
drop `v'
rename _`v' `v'
}
save  data_done,replace