EViews.com

Hi there,

I am trying to import annual data from excel to eviews using the frequency conversion cubic to convert it to quarterly.

When I run the code:
import(mode="o", page="original_data", c=c) X:\StateSpace_BoC\Eviews\Data\datastream_g10.xlsx range="debt_annually!B2:G34" @smpl @freq q 1980 @rename *OCFNB_ nfl_*

I get the error message:
Unrecognized contraction option: c in "IMPORT(MODE="O", PAGE="ORIGINAL_DATA", C=C) X:\STATESPACE_BOC\EVIEWS\DATA\DATASTREAM_G10. ...

I have tried moving the c=c argument around, putting a quotation mark around the c, without any success.

Any idea why I get the error message?

Thanks for your help,

Mara

The documentation for the import command options when converting from a low to higher frequency is incorrect . The import command only support simple conversion methods. The docs should read for low to high conversion:

e=arg

where arg is one of the following:

f - first observation
l - last observation
r - repeat observations
d - distribute observations

So your command should be If you must use cubic match, import your series into a new annual workfile and then copy the series from the annual workfile to your quarterly workfile via the 'copy' command. The 'copy' command supports the cubic match last conversion method.

thanks very much for your reply.