4-week structured data

For questions regarding the import, export and manipulation of data in EViews, including graphing and basic statistics.

Moderators: EViews Gareth, EViews Jason, EViews Steve, EViews Moderator

jccondi
Posts: 7
Joined: Fri Jun 01, 2018 8:02 am

4-week structured data

Postby jccondi » Fri Apr 03, 2020 8:09 am

Hi,

I have to deal with a database which is structured as a 4-week monthly data. It has 48 observations for each year (4 weeks for each of the 12 months).
I was correcting that problem in Excel, using a previous weekly data table imported from Eviews, and making a Vlookup on it and then exporting to Eviews. But it happens that the weekly structure from Eviews sometimes is not compatible with a 4-week data table like that. For example, the last observation of a month (the 4º week of month t) may appear as the first observation of the following month (1º week of month t+1), which is a mistake I am trying to avoid, but I couldn't figure out how to deal with it so far.

Is there any way of solving it?

Thanks

Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 12 guests