Hi,

I imported data and merged it with other (pane)l data. Reshaping the data resulted in this message: "There are multiple observations on the same Date within ID_S."

I guess it is based o the fact that on the same day multiple (and additive) values are found in the dataset. You can see it in the sample (the value of 163.607). Stata is technically showing this as a duplicate.

I don't know how to deal with it as double dates cause problems.

Any idea highly appreciated.


Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input int Date double Debt_amount str7 ID_S double(Equity_amount Repurchase_amount) str9 Status
16821       . "U295141" 163.607      . ""         
16821       . "U295141" 163.607      . ""         
16824       . "U904391"       . 98.269 "Completed"
16824       . "U30709W"   16.08      . ""         
16825       . "F922029" 738.082      . ""         
16826 605.801 "D882362"       .      . ""         
end
format %td Date