Page 1 of 1
Import Data in the same workfile
Posted: Mon Sep 05, 2011 9:01 pm
by 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.
Re: Import Data in the same workfile
Posted: Tue Sep 06, 2011 9:23 am
by EViews Glenn
Don't use read, use import.
Re: Import Data in the same workfile
Posted: Tue Sep 06, 2011 6:19 pm
by 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.
Re: Import Data in the same workfile
Posted: Tue Sep 06, 2011 7:21 pm
by 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.
Import Data in the same workfile
Posted: Wed Sep 07, 2011 6:25 am
by EViews Gareth
You need EViews 7 to use IMPORT.
Re: Import Data in the same workfile
Posted: Wed Sep 07, 2011 11:46 am
by EViews Glenn
You *can* use the merging features of EViews to combine data from different pages in the same workfile.
Re: Import Data in the same workfile
Posted: Mon Sep 26, 2011 1:40 am
by 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.
Import Data in the same workfile
Posted: Mon Sep 26, 2011 6:56 am
by EViews Gareth
Copy, or pageappend.
Re: Import Data in the same workfile
Posted: Fri Feb 10, 2012 2:22 pm
by 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.
Re: Import Data in the same workfile
Posted: Fri Feb 10, 2012 3:11 pm
by EViews Gareth
Code: Select all
import(page=inputs) <file1> <pagename> @freq Q <some date>
Where <pagename> is the name of the page.