error message when importing with frequency conversion

[maragloria]

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

[EViews Jason]

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

Code: Select all

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

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.

[maragloria]

thanks very much for your reply.