Page 1 of 1
Data format from Excel
Posted: Sat Jul 25, 2015 12:05 pm
by H_Boss
Hi,
Does Eviews8 compute data in different sheets in Excel (1 series in each sheet) ?
Panel data (Countries in 1st column, years in 1st line).
Thank you,
H_Boss
Re: Data format from Excel
Posted: Sat Jul 25, 2015 12:59 pm
by EViews Gareth
Yes.
Re: Data format from Excel
Posted: Sat Jul 25, 2015 1:11 pm
by H_Boss
Thanx.
What do I have to do?
The tutorial I saw stated that all data must be in the same sheet.
Re: Data format from Excel
Posted: Sat Jul 25, 2015 1:21 pm
by EViews Gareth
When you try importing an Excel file, EViews asks you which sheet you want to open
Re: Data format from Excel
Posted: Sat Jul 25, 2015 1:30 pm
by H_Boss
All of them. 1 series in each sheet.
Re: Data format from Excel
Posted: Sat Jul 25, 2015 1:44 pm
by H_Boss
I have the data in table format.
I was trying to not have to convert it to single column (series).
Re: Data format from Excel
Posted: Sat Jul 25, 2015 2:02 pm
by H_Boss
Is it possible to make Eviews read 1 series from 1 sheet instead of a column?
Re: Data format from Excel
Posted: Sat Jul 25, 2015 3:47 pm
by EViews Gareth
I think it is best if you go into considerably more detail as to what you're trying to do, and if possible provide the data files.
Re: Data format from Excel
Posted: Sun Jul 26, 2015 5:54 am
by H_Boss
I converted data in sheet "Fossil pc", to the format shown in "fossil new" (single column).
Is it possible to make EViews read the data from "Fossil pc", as well as other sheets, and compute them alltogether?
(recognizing all data in the sheet as 1 series, other series in other sheets).
HB