Merge 2 xls files into one workfile

For questions regarding programming in the EViews programming language.

Moderators: EViews Gareth, EViews Moderator, EViews Jason, EViews Matt

atbui
Posts: 2
Joined: Tue Sep 15, 2009 9:06 pm

Merge 2 xls files into one workfile

Postby atbui » Tue Sep 15, 2009 9:32 pm

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
Attachments
occasional_paper_10.xls
(1.36 MiB) Downloaded 426 times
F01Dhist(1).xls
(794.5 KiB) Downloaded 448 times

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13604
Joined: Tue Sep 16, 2008 5:38 pm

Re: Merge 2 xls files into one workfile

Postby EViews Gareth » Tue Sep 15, 2009 10:35 pm

Probably the easiest thing to do is to open each one as separate workfiles, then copy from one workfile into another.

atbui
Posts: 2
Joined: Tue Sep 15, 2009 9:06 pm

Re: Merge 2 xls files into one workfile

Postby atbui » Wed Sep 16, 2009 12:07 am

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

fmgoto
Posts: 76
Joined: Thu Jan 15, 2009 5:01 am
Location: Brasilia, Brazil

Re: Merge 2 xls files into one workfile

Postby fmgoto » Wed Sep 16, 2009 1:37 pm

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


Return to “Programming”

Who is online

Users browsing this forum: No registered users and 1 guest