Page 1 of 1

Import Problem

Posted: Thu Nov 29, 2012 5:56 am
by 88fr.leo
Hello, my name is Leo, maybe you are able to help me.

In one file I have two worksheet, on with a monthly frequency and another with a custom frequency (from 1 to 12 - what means that it is annual).
I have a serie in the monthly one and i want to "break" it into another series the other frequency worksheet, but I want that every january be into number 1, february 2 till december 12. And if this is possible, the program should name the new series with the current year that it is representing.
It is like taking one stack and make another stacks with the same number of information.


Thx :D

Re: Import Problem

Posted: Thu Nov 29, 2012 8:50 am
by EViews Gareth
I don't follow. The second sheet is annual, and covers twelve years? Does the first sheet also cover those 12 years?

Re: Import Problem

Posted: Thu Nov 29, 2012 9:11 am
by 88fr.leo
I made a file trying to explain my problem. The File I have is monthly and I want to import this file in a "custom" way. In the excel I am sending have the information necessary.

Re: Import Problem

Posted: Thu Nov 29, 2012 9:19 am
by EViews Gareth
Still not sure I fully understand, but try:

Code: Select all

wfopen test.xlsx range="Monthly!a1:b228" pageunstack @year @month @ currency