Page 1 of 1
Merge 2 xls files into one workfile
Posted: Tue Sep 15, 2009 9:32 pm
by atbui
I am a new eviews user. I have two excel file (i.e. F01Dhist(1).xls and occasional_paper_10.xls) I would like to merge two file in to one workfile. data prior to 1 jan 1995 use occasional_paper_10.xls and after 1 jan 1995 are F01Dhist(1).xls.
Thank you very much
Re: Merge 2 xls files into one workfile
Posted: Tue Sep 15, 2009 10:35 pm
by EViews Gareth
Probably the easiest thing to do is to open each one as separate workfiles, then copy from one workfile into another.
Re: Merge 2 xls files into one workfile
Posted: Wed Sep 16, 2009 12:07 am
by atbui
Probably the easiest thing to do is to open each one as separate workfiles, then copy from one workfile into another.
Thanks. However, I would like to write code to since it is only part of my programme. Would you please show me code for this case
Re: Merge 2 xls files into one workfile
Posted: Wed Sep 16, 2009 1:37 pm
by fmgoto
You may either add rows to your shorter Excel file or use the read command twice: once for smpl @first 1995m01 and then for smpl 1995m01 @last. Is that it? Fabio