Data input: READ, IMPORT

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

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

shuchang
Posts: 29
Joined: Mon Oct 28, 2013 8:00 pm

Data input: READ, IMPORT

Postby shuchang » Tue Jul 19, 2016 1:09 am

Hi Gareth,

I am a long term Eviews user, but new to Eviews 9. I have great problems inputting data into a wf, and the READ I am so familiar with doesn't work now. I got empty series (no data, no heading) when using the commands:

read(b2, t=xls, sheet=total) volume_boe_eviews.xls 1
read(b2, t=xls, sheet=ndf) volume_boe_eviews.xls 8
read(b2, t=xls, sheet=df) volume_boe_eviews.xls 8
read(b2, t=xls, sheet=spot) volume_boe_eviews.xls 8
read(b2, t=xls, sheet=swap) volume_boe_eviews.xls 8

Please advise what to do. Also what would be the IMPORT command for doing this?

Best,

Chang
Attachments
volume_boe_eviews.xls
(95 KiB) Downloaded 563 times
test.wf1
(7.98 KiB) Downloaded 331 times

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

Re: Data input: READ, IMPORT

Postby EViews Gareth » Tue Jul 19, 2016 6:29 am

Code: Select all

import volume_boe_eviews.xls range="total"

shuchang
Posts: 29
Joined: Mon Oct 28, 2013 8:00 pm

Re: Data input: READ, IMPORT

Postby shuchang » Tue Jul 19, 2016 6:36 am

I tried the import command. I got the message: 'incomplete date spec (no start date)'

EViews Steve
EViews Developer
Posts: 844
Joined: Tue Sep 16, 2008 3:00 pm
Location: Irvine, CA

Re: Data input: READ, IMPORT

Postby EViews Steve » Tue Jul 19, 2016 8:24 am

If you manually drag the spreadsheet onto EViews, and use our Import wizard to perform the import, it will generate an IMPORT command in the capture window for you to use in your programs with all the proper settings.

shuchang
Posts: 29
Joined: Mon Oct 28, 2013 8:00 pm

Re: Data input: READ, IMPORT

Postby shuchang » Wed Jul 20, 2016 12:21 am

Thanks.

Do you recommend to use IMPORT rather than READ now? The READ command I was so familiar with doesn't work now.



chang

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

Re: Data input: READ, IMPORT

Postby EViews Gareth » Wed Jul 20, 2016 6:21 am

We stopped supporting READ in EViews 4.

EViews Steve
EViews Developer
Posts: 844
Joined: Tue Sep 16, 2008 3:00 pm
Location: Irvine, CA

Re: Data input: READ, IMPORT

Postby EViews Steve » Wed Jul 20, 2016 7:46 am

As an aside, maybe we should start warning our users when they use deprecated commands in their programs. Not sure where we would show that though -- maybe the program log window (if there is one).

shuchang
Posts: 29
Joined: Mon Oct 28, 2013 8:00 pm

Re: Data input: READ, IMPORT

Postby shuchang » Wed Jul 20, 2016 8:01 am

This might be useful indeed. For example, I always used READ as the main input method and didn't realise that it's outdated until this time it failed to work.

Many thanks.

Best,

Chang


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 1 guest