Search found 26 matches

by fi99ggb
Thu Sep 03, 2020 11:48 am
Forum: Programming
Topic: loop with dates / panel
Replies: 1
Views: 6106

loop with dates / panel

Hello I have a panel dataset and I want to run a loop to sequentially increase the time dimension of the sample like: for !i = 1 to 12 smpl @first 2012M12+!i ...estimate equation next I am bit confused but it looks like this does not increase the time dimension of the sample. Is that right? And is t...
by fi99ggb
Wed Apr 15, 2020 11:50 pm
Forum: Programming
Topic: EViews/Oracle connection
Replies: 2
Views: 4301

Re: EViews/Oracle connection

Thanks, Steve. Makes sense.
by fi99ggb
Wed Apr 15, 2020 8:31 am
Forum: Programming
Topic: EViews/Oracle connection
Replies: 2
Views: 4301

EViews/Oracle connection

Hello I have managed to connect EViews with Oracle and run my code on a daily basis through the Windows task scheduler. The process involves, among other things, fetching data from Oracle, manipulating the data, estimating models and pushing data back to Oracle. The process is fully automated and ru...
by fi99ggb
Sun Apr 12, 2020 3:20 am
Forum: Programming
Topic: setmaxerrs - syntax error in control statement
Replies: 6
Views: 6915

Re: setmaxerrs - syntax error in control statement

Thanks Matt. I appreciate the help.
by fi99ggb
Thu Apr 09, 2020 11:02 pm
Forum: Programming
Topic: setmaxerrs - syntax error in control statement
Replies: 6
Views: 6915

Re: setmaxerrs - syntax error in control statement

Hi Matt Thanks for your reply. I get the same error regardless of the setmaxerrs value. I set out below an example code to explain where I typically get the error. If the dataset is missing, EViews stops despite the setmaxerrs. Is there a way for EViews to ignore this error? Thanks George '=========...
by fi99ggb
Thu Apr 09, 2020 7:20 am
Forum: Programming
Topic: setmaxerrs - syntax error in control statement
Replies: 6
Views: 6915

Re: setmaxerrs - syntax error in control statement

Hi Matt I typically encounter these errors when a WF does not exist or a variable is not defined and I reach the point where I have a for-loop command. Most importantly, what I am trying to do is to continue "executing" the code until the end of the file is reached where I instruct EViews ...
by fi99ggb
Thu Apr 09, 2020 3:28 am
Forum: Programming
Topic: setmaxerrs - syntax error in control statement
Replies: 6
Views: 6915

setmaxerrs - syntax error in control statement

Hello

I am using the setmaxerrs command to ignore errors and works fine in the majority of the errors encountered. However, it looks like execution is halted when the error is in relation to a for/loop. Is there a way around it? Am I missing something?

Thanks
George
by fi99ggb
Wed Apr 08, 2020 1:10 am
Forum: Programming
Topic: Error handling
Replies: 2
Views: 3339

Re: Error handling

Thank you!
by fi99ggb
Mon Apr 06, 2020 3:07 am
Forum: Programming
Topic: Error handling
Replies: 2
Views: 3339

Error handling

Hello I am using the setmaxerrs to handle processing errors; however, there are cases when EViews naturally stops, for example, when a file I am instructing to open does not exist or when a file cannot be reshaped. In those cases, I would like to manage the error. For example, when EViews stops I wo...
by fi99ggb
Tue Mar 10, 2020 2:35 am
Forum: Programming
Topic: Pagesave(type=ODBC)
Replies: 4
Views: 6669

Re: Pagesave(type=ODBC)

Hi Steve

Great, thanks for this (I thought I was going crazy..).

George
by fi99ggb
Mon Mar 09, 2020 7:37 am
Forum: Programming
Topic: Pagesave(type=ODBC)
Replies: 4
Views: 6669

Re: Pagesave(type=ODBC)

Hi Steve I attach the image. When we call the table without quotes around the table name there is no table available. Is this helpful? The database is Oracle. Another perhaps unrelated subject is related to the variable names. Do you know why some variables have quotes around them and are in lower c...
by fi99ggb
Wed Mar 04, 2020 3:48 am
Forum: Programming
Topic: Pagesave(type=ODBC)
Replies: 4
Views: 6669

Pagesave(type=ODBC)

Hello I am using the following code to save an EViews page on SQL database: pagesave(type=ODBC) C:/Eviews/SARASEviews.dsn ev_depot_demand @all keep x1 x2 x3 The problem is that the table is saved with double quotes ("ev_depot_demand"). Do you know why this is the case and a way around it? ...
by fi99ggb
Tue Dec 24, 2019 8:49 am
Forum: Programming
Topic: Task Scheduler for multiple prg files
Replies: 3
Views: 6167

Re: Task Scheduler for multiple prg files

Thanks Steve. I appreciate your quick response (on a Saturday). I resolved the issue. It was not associated with the insert command. Potentially there is a bug. if the program I call (through the scheduler) and/or the folder where the program is saved starts with a numeric character (e.g. 0.Run, 1. ...
by fi99ggb
Fri Dec 20, 2019 5:35 am
Forum: Programming
Topic: Task Scheduler for multiple prg files
Replies: 3
Views: 6167

Task Scheduler for multiple prg files

Hello I have set up a file that runs multiple program files using the include command and runs fine when I run the file manually. When using the windows task scheduler, the program is shown as running (for a long period) without producing any results (e.g. exporting files). Any ideas why this is hap...
by fi99ggb
Wed Oct 09, 2019 3:15 am
Forum: Programming
Topic: Error notification
Replies: 1
Views: 3543

Error notification

Hello I have a program that runs daily and would like to be able to set up an automatic process that notifies me whether a program runs as intended. For example, if the data structure does not satisfy some conditions, I would like EViews to stop and create a message that tells me that something is w...

Go to advanced search