Hi there,

I am new to Stata and I started last week as a total newbie.

What I want to do is to check the connection of the exchange rate to the demand of hotel bookings of foreigners. I have the data from hotel nights and the exchange rate on a monthly basis (end of month). However, Stata does not seem to understand the dates that I imported from Excel (formatted there as dates).

I tried to change the properties of the variable that I called "month" but it seems not to work (type is "int" and format is set to: "%tmCCYY-NN".

It looks like this:
month
3332-04
3334-08
3337-03
3342-04

I read in the help section and searched on youtube but did not find a solution. I guess it is probably easy to solve this but currently I am lost.

What can I do?

Any help very much appreciated...

Michael