Commands for merging large daily data files

[Thea]

Hi,

I'm trying to carry out regression analysis upon 1/2 hourly data from 1/4/2005 to 31/12/2010 in Eviews 6.

Given that Eviews 6 does not have intraday frequencies, I've decided to treat them as daily frequencies over a longer time period. And this seems good enough!

However, I'm still having problems getting the data into Eviews, given that I have 100,850 observations and Eviews 6 is not compatable with xlxs and xls can only handle fewer data within a single workbook.

I've split the workbook into two and I'm trying to now merge the data. But I keep on getting error messages. It says 'invalid ID link in link specification'. I've provided my program code below (the files are too big to attach and post too). I'm probably doing something very obviously wrong! Any help would be very appreciated.

Thank you,

Thea.

'Creating 2nd worfile

wfcreate(wf=UP) 7 4/24/1914 12/31/2010

'Importing the data

read(c3,s=Summary) "Filepath\Econometric summary II.xls" capacity price peak srmc

'creating workfile for the first set of data

wfcreate(wf=LIFT) 7 11/19/1734 12/31/2010

'Importing the data

read(c3,s=Summary) "Y:\Explorer data\Econometric summary I.xls" capacity price peak srmc

'Trying to merge files - appending does not work because it gets rid of the date structure. And I cannot get the syntax right for copying...

copy up::\capacity @src @date @dest @date

[EViews Gareth]

Use the pageload command to open them up in two different pages. Then use the pageappend command to put them on top of each other. Using READ is probably a bad idea.