Import Data in the same workfile

[fitria]

hi,
i'm little bit confuse about combine data from different excel source in the same workfile, i have this program but it didn't worked out

Code: Select all

%folder = "I:\Stock Area\Data Saham\Data Lengkap\" %input1 = %folder + "data saham fix.xls" %input2 = %folder + "data saham fix2.xls" %output = %folder + "stock" wfopen %input1 read %input2 save %output

i want to combine the data from data saham fix.xls and data saham fix2.xls in the same workfile (stock.wf1).
is there anything wrong in this program?
thank you so much.

[EViews Glenn]

Don't use read, use import.

[fitria]

ok.
when i replace read with import, this program also didn't worked out. it said "IMPORT is not defined or is an illegal command". so, what should i do?
thank you.

[fitria]

sorry i mean. i want to combine data from that sources in the same page. if in the same workfile, there is a possibility to combine data in different page, right?
thank you.

[EViews Gareth]

You need EViews 7 to use IMPORT.

[EViews Glenn]

You *can* use the merging features of EViews to combine data from different pages in the same workfile.

[stevecsp]

Hi, eviews

If I am still using eview 6, and I have "wfopen"ed many external resources of workfiles. How can I combine them together into one workfile? My current method is copy the series one by one into the new workfile. Is there any other alternatives? Is there a function that I can merge one workfile into another workfile? Thank you very much.

[EViews Gareth]

Copy, or pageappend.

[Mickster]

Hello!

I would like to import some data from one Eviews workfile to another newly-created workfile, which I have been able to do with the following code:

Code: Select all

wfcreate(wf=data,page=inputs) Q <range begin> <range end> import(page=inputs) <file1> @freq Q <some date>

While this works just fine for my particular process, I've noticed that if file1 isn't saved on the specific page where my inputs are located, the program will shortly fail when it tries to use those inputs. Is there a way to specify a page in file1 to import so that I don't have to worry about which page in file1 was displayed when I last saved it? Would some other command be more suitable to load data just from one page into a new file?

Thanks!

EDIT: I am using Eviews 7.2.

[EViews Gareth]

Code: Select all

import(page=inputs) <file1> <pagename> @freq Q <some date>

Where <pagename> is the name of the page.