Loading data

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

ral
Posts: 23
Joined: Tue Oct 21, 2014 2:44 pm

Loading data

Postby ral » Thu Oct 23, 2014 9:26 am

I have a simple problem that is driving me crazy. I am trying to load some data into an Eviews workfile. When I attempt to import the 49 data series, I obtain NAs rather than the data themselves.

Here is the code:

cd ...\mydirectory

wfcreate(wf="persistwgtpi", page="monthly") m 1980M1 2014M9

' Read in data
' Change sheet for different countries
read(b2,s=sweden) cpisubcomp.xlsx 49

Thanks in advance.
Attachments
cpisubcomp.xlsx
(159.76 KiB) Downloaded 338 times

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

Re: Loading data

Postby EViews Gareth » Thu Oct 23, 2014 9:27 am

The READ command has not been supported since EViews 4. As such it does not support .xlsx files. Use WFOPEN or IMPORT instead.


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 2 guests