How to perfectly match dates when importing from Excel
Posted: Fri Nov 13, 2015 7:57 am
I have daily data in Excel which I aim to import to Eviews using the import command. The data is in general listed on a daily working day basis, such that there is 5 observations per week. This suggests using import ....@freq D5.... However, for some few weeks my data has less than 5 observations. So when I import the data to Eviews, the data does not perfectly correspond to the dates that I had in my excel file (the data in the Eviews work file end earlier in time). Is there anyway to solve this in Eviews so that my Eviews workfile is a perfect match of the Excel file when it comes to the dates when observations were made?
Many thanks for your help.
Many thanks for your help.