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
Merge 2 xls files into one workfile
Moderators: EViews Gareth, EViews Moderator, EViews Jason, EViews Matt
Merge 2 xls files into one workfile
- 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
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
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 caseProbably 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
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
Who is online
Users browsing this forum: No registered users and 2 guests
