Commands for merging large daily data files
Posted: Fri Mar 11, 2011 8:38 am
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
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