Hello, I have a large dataset which I receive in 5 excel files. There is a variable, lets say X, this variable appears as double in some excel files and in others it appears as string. The problem is, they change everyday, for example, Excel 1 might contain X in double format one day and the next day, it might be string. Therefore, the code tostring X, gen(strX) format(%15.0f) does not always work. Is there a way to code this so that I don't have to change the programme every time? perhaps a conditional conversion?