Convert from double to string to append multiple datasets

[Noah Ganoal]

Dear Statalisters,

When I try to append multiple datasets, I encounter a problem with different data types. Overall, I convert all variables (type mismatch) into "str". However, it does not work for a variable containing information about time, for example: 09:45. This variable is in "double" in some datasets, "int" in some datasets, and "str" in some others.
The error is: ... cannot be converted reversibly; no replace
I have read this post: https://www.statalist.org/forums/for...uble-to-string, but I don't know how to do in my case.
I would appreciate any advice on my case.

Thanks

[Andrew Musau]

EDITED: Time variables should be stored as double. Can you give a dataex example of those stored as int and str formats? I think the best approach is to convert each to double in the respective datasets before merging. However, you can convert a time variable (SIF values) to string as below:

gen wanted= string(timevar, "%20.0f")

[Noah Ganoal]

It works. Thanks alot, Andrew.