Excel Import: Date Issues

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

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

nchesley
Posts: 3
Joined: Sun Oct 26, 2008 12:18 pm

Excel Import: Date Issues

Postby nchesley » Tue Dec 09, 2008 11:16 pm

Hi,

I've imported a .xls table into eViews with the date in column A and multiple series' in columns B-M. eViews is taking the DATE data in column A and creating a separate series; further, the observations in my analysis (sample selections, graphs, tables, etc.) displays numbers 1 - 465 instead of Jan 31, 1970 - Aug 31, 2008. How can I update the ID on each observation to be the corresponding dates not numerical values?

Thanks,
NC

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 11378
Joined: Tue Sep 16, 2008 5:38 pm

Re: Excel Import: Date Issues

Postby EViews Gareth » Wed Dec 10, 2008 9:48 am

You need to restructure your workfile so that it has the correct format. You can do this by clicking on Proc->Structure/resize current page.

You probably want "Dated - Specified by Date Series".
Follow us on Twitter @IHSEViews

nchesley
Posts: 3
Joined: Sun Oct 26, 2008 12:18 pm

Re: Excel Import: Date Issues

Postby nchesley » Sat Dec 13, 2008 3:14 pm

That work nicely. Thanks so much! :D

Best,
NPC


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 9 guests