open copy and Windows 7

[KOBE24]

Dear Tom,

I have a problem with the open copy instruction.

I want to save a bunch of series in an .xls file, hence I write the following lines

open copy fin_factors.xls
copy(format=xls,org=obs, dates) / finfactor1
close copy

The response I obtain is the following

## IO43. Format EXCEL is illegal or not supported

Even stranger, the instruction perfectly works on Windows XP, while I have Windows 7 (the outcome is the same, irrespective of the machine where the code is running, i.e., it gives always the same error message for each Windows 7). Any known bug? Any suggestions?

Thanks in advance for your help!

[TomDoan]

You would have to show me the entire program. You can't use FORMAT=XLSX, but FORMAT=XLS or FORMAT=EXCEL should be fine. What version of RATS are you using?

[KOBE24]

Dear Tom,

thanks for your reply. I am running a very basic FAVAR model for some macro variables, and interested in extracting a sort of composite financial indicator.
However, as you can note in what follows, the problem does not depend on the model I am running: here is a code in which I just take some log of the RAW series, and I try to use open copy.

The error message is always the same!

## IO43. Format EXCEL is illegal or not supported

I am using RATS8 & Office2010.
RATS 7 & Office 2003 (XP) is fine. RATS 8 & Office 2003 is fine as well.
The weird thing is that a combo of RATS7 & Office 2010 seems to do the job!
That's why I was wondering whether any known bugs were detected on RATS8 in relation to open copy.

Not only xls, but also excel format were declared impossible.
Also, neither org=col, neither org=obs.

Hope it helps, thank you in advance!

Code: Select all

*******	====================================================================================	*******
*******									 FAVAR model
*******	====================================================================================	*******


calendar 2003 1 12
allocate 2012:09
open data dataset.xls
data(format=xls,org=obs)
close data
*****table /


*******	====================================================================================	*******
*******									preliminaries																	*******
*******	====================================================================================	*******

set eam1 		= log(ea_m1)
set eam2 		= log(ea_m2)
set eam3 		= log(ea_m3)
set ealhh 	= log(ea_loans_hh)
set ealnfc 	= log(ea_loans_nfc)

set eamro		= log(mro)
set ealtro     = log(ltro)
set eadep      = log(dep)

set eadj		= log(ea_dow)
set eadjb      = log(ea_dow_bank)
*******	====================================================================================	*******
open copy datanew.xls
copy(format=excel,org=col, dates) / eam1 eam2 eam3
close copy

[TomDoan]

I have no idea what you mean by RATS 8 and Office 2013 is "fine", but RATS 8 and Office 2010 doesn't work. Are those different computers? Because what version of Office you are using has nothing to do with that error message---it can't have any effect on how RATS interprets that instruction. What is the exact version of RATS that doesn't seem to work---check the "About RATS" on the Help menu?

[KOBE24]

Dear Tom,

by saying that RATS8 and Office 2003 is "fine" I mean that if I run the same code by using WinRATS 7.0, on the same machine, it correctly produces the file excel.
By contrast, using the version RATS version 8.00 c(2010), it gives me the error message.

Hope it clarifies your doubts!

thanks, as usual, for your kind reply!