Dear community,
as I am a new user, I am not used to the syntax used in this forum. Though, please be patient if I do not provide the required information.
I am using Stata Version 13.1 for Mac and striving to merge two datasets.
Unfortunately, the content within the cells of the merged file, differs from the content of the original dataset.
Example 1:
Original dataset: ret_mkt at 01mar2005: 3,823.30; format: %14.2fc, type: double
Merged dataset: ret_mkt at 01mar2005: 823.30; format: %15.4 gc, type: doubl)
Example 2:
Original dataset: open_mkt at 01mar2005: 3,881.36; format: %14.2fc, type: double
Merged dataset: open_mkt at 01mar2005: 936.58 displayed (but if you activate the cell by clicking on it, you can see a value of 3234); format %14.2fc, type: double
I used the following commands:
use "/Users/juliacatharinajensen/Documents/Paderborn/Daten/20170308 stockdata3.dta"
sort country_id date
save, replace
merge m:1 country_id date using test, update
sort _merge
browse
Do you have any advice for me? I already searched within the old posts and studied the help site, but I was not able to solve the problem. Thank you!
Regards, Julia
as I am a new user, I am not used to the syntax used in this forum. Though, please be patient if I do not provide the required information.
I am using Stata Version 13.1 for Mac and striving to merge two datasets.
Unfortunately, the content within the cells of the merged file, differs from the content of the original dataset.
Example 1:
Original dataset: ret_mkt at 01mar2005: 3,823.30; format: %14.2fc, type: double
Merged dataset: ret_mkt at 01mar2005: 823.30; format: %15.4 gc, type: doubl)
Example 2:
Original dataset: open_mkt at 01mar2005: 3,881.36; format: %14.2fc, type: double
Merged dataset: open_mkt at 01mar2005: 936.58 displayed (but if you activate the cell by clicking on it, you can see a value of 3234); format %14.2fc, type: double
I used the following commands:
use "/Users/juliacatharinajensen/Documents/Paderborn/Daten/20170308 stockdata3.dta"
sort country_id date
save, replace
merge m:1 country_id date using test, update
sort _merge
browse
Do you have any advice for me? I already searched within the old posts and studied the help site, but I was not able to solve the problem. Thank you!
Regards, Julia
