Error Seats.itr not found

For questions regarding programming in the EViews programming language.

Moderators: EViews Gareth, EViews Moderator, EViews Jason, EViews Matt

vita
Posts: 4
Joined: Tue Jul 27, 2010 9:14 am

Error Seats.itr not found

Postby vita » Tue Jul 27, 2010 9:39 am

Hello,

I am working with a programm created on EViews 6, however I am running this programm on a computer with EViews 7. This program gets some series from an excel file, then calculates the monthly percentage change and after that it seasonally adjusts these series using tramo seats, however when I try to run the programm there is a message that says: d:\USERPR~1\Name\AppData\ev_temp\TRAMO\seats.itr not found on the disk in "DO_SERIES11.M.TRAMOSEATS (SAVE="SA", RUNTYPE=TS, OPT="IMEAN=0 AIO=0 SEATS=2"). I have used this programm before but with EViews 6 and I didn't have any problems. Could you please tell if I have to change the command (the command is name_of_the_series.tramoseats(save="sa", runtype=ts, opt="IMEAN=0, aio=0 seats=2") or if it is not a problem of the command?. Thanks in advance.

EViews Jason
EViews Developer
Posts: 870
Joined: Tue Sep 16, 2008 3:50 pm

Re: Error Seats.itr not found

Postby EViews Jason » Tue Jul 27, 2010 10:13 am

The error message is a bit strange in that it indicates the series name to be "DO_SERIES11.M". This is not a valid EViews series name. Post your lines of code which constructs the series name as well the line that executes TRAMO. I suspect this to be the culprit and that EViews is giving a misleading error message.

To verify TRAMO does work in your EViews 7 copy, open a workfile, pick a series and type in the command window

Code: Select all

name_of_the_series.tramoseats(save="sa", runtype=ts, opt="IMEAN=0, aio=0 seats=2")
Please post your findings.

vita
Posts: 4
Joined: Tue Jul 27, 2010 9:14 am

Re: Error Seats.itr not found

Postby vita » Tue Jul 27, 2010 12:20 pm

Thanks for the rapid response. I checked and tramo seats does work if I use other workfile. However, I opened the series that EViews is trying to seasonally adjust and the series has no values (it is all full with NAs), so the problem I suppose is that EViews is not importing excel data properly.
The thing is that I changed the commands of the program (from using "read" to "import" because I am using the EViews 7 to read Excel 2007 files)
The original command specified the number of series EViews had to get from different worksheets of the same file, for example:

read(B104, s=worksheet1) "D:\file.xls" 220

being 220 the number of series I want EViews to get from worksheet1 of file.xls (series starting on B104)

The new command I am using is:
import "D:\file.xlsm" range="worksheet1!B104" @freq m 2002m7

The thing is that I cannot define an specific range of cells because each month I add a new observation of the series (I do that in EViews using dateadd command). I think the problem is that I am not defining how many series I want EViews to get from the three worksheets I am using. How can I specify how many series I want to import from excel on the new code? Thanks in advance.

EViews Jason
EViews Developer
Posts: 870
Joined: Tue Sep 16, 2008 3:50 pm

Re: Error Seats.itr not found

Postby EViews Jason » Tue Jul 27, 2010 2:13 pm

If there isn't data to the right or below the desired region, EViews will automatically import the right and bottom most observation. If there is data to the right you could use '@drop=' to remove any extraneous series. But if the series names change or if there are lot of series to remove this may be difficult.

Another option would be to name the region within excel and then just import that region.

If you can provide a more detailed description on how the spreadsheet is laid out and which observations you wish to import, I may be able to provide a better solution.


Return to “Programming”

Who is online

Users browsing this forum: No registered users and 2 guests