Data format from Excel

[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

[EViews Gareth]

Yes.

[H_Boss]

Thanx.
What do I have to do?
The tutorial I saw stated that all data must be in the same sheet.

[EViews Gareth]

When you try importing an Excel file, EViews asks you which sheet you want to open

[H_Boss]

All of them. 1 series in each sheet.

[H_Boss]

I have the data in table format.
I was trying to not have to convert it to single column (series).

[H_Boss]

Is it possible to make Eviews read 1 series from 1 sheet instead of a column?

[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.

[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