Search found 17 matches

by BCNAV
Sat Nov 18, 2017 7:54 am
Forum: Programming
Topic: Automating Import from SAS
Replies: 2
Views: 62

Re: Automating Import from SAS

Here is what I ended up with....any suggestions or issues? 'Database should have up to current year of data in it !year=2000+@right(@date,2) 'Where the database is located %dbname="R:\Eviews\Databases\Testing\navts_test.edb" 'If the database exists, delete it, since we want to rewrite it w...
by BCNAV
Fri Nov 17, 2017 1:53 pm
Forum: Programming
Topic: Automating Import from SAS
Replies: 2
Views: 62

Automating Import from SAS

I have some SAS databases that are regularly made that I want to convert into an EViews database. To start I have: !year=2000+@right(@date,2) wfcreate test m 2000 !year import R:\Eviews\SAS_Data\nav_data_all_ts.sas7bdat @freq m 2000 delete date Now, I am unsure how to setup the database and copy all...
by BCNAV
Fri Nov 17, 2017 9:26 am
Forum: Programming
Topic: IF Statement on a Variable Name
Replies: 2
Views: 78

Re: IF Statement on a Variable Name

I ended up messing around and found:

Code: Select all

   if @left(({%series}.@name),3)="OVR"


I didn't realize that if I removed the braces it would be good. Thanks
by BCNAV
Fri Nov 17, 2017 8:17 am
Forum: Programming
Topic: IF Statement on a Variable Name
Replies: 2
Views: 78

IF Statement on a Variable Name

I have: %vars="ovr_amt_m11 ovr_amt_m14 ovr_amt_m22 ovr_amt_m23 ovr_amt_ktk ovr_amt_oth ter_amt_m11 ter_amt_m22 ter_amt_m33 ter_amt_m34 ter_amt_m35 enr_amt_m11 enr_amt_m22 enr_amt_m33 enr_amt_m34 enr_amt_m35" genr overflight = ovr_amt_m11+ovr_amt_m14+ovr_amt_m22+ovr_amt_m23+ovr_amt_ktk+ovr_...
by BCNAV
Tue Nov 14, 2017 10:35 am
Forum: Programming
Topic: Exporting R-SQU to Excel
Replies: 3
Views: 90

Re: Exporting R-SQU to Excel

Thanks...I had tried a table, but EViews still cannot export an excel table. Only CSV, and CSV won't work for linking to another XLS. Any reason why this has not been added to EViews? In any case, how would the matrix work? I tried: matrix a_rsq2 !rowcount=1 for %series {%vars} smpl @first %history_...
by BCNAV
Tue Nov 14, 2017 9:28 am
Forum: Programming
Topic: Exporting R-SQU to Excel
Replies: 3
Views: 90

Exporting R-SQU to Excel

I am running a batch of ARIMAs: genr tot_ecu_hf=0 group a_results for %series {%vars} smpl @first %history_end_date freeze(mode=overwrite,{%series}_stats) {%series}.autoarma(tform=auto,diff=2,select=aic,periods=12,kpsssig=5,eqname={%series}_eq,maxar=4,maxma=3,maxsar=1,maxsma=1,seed=131071,forclen={!...
by BCNAV
Fri Nov 10, 2017 8:47 am
Forum: Programming
Topic: Calculating Forecast Length via Dates
Replies: 1
Views: 69

Calculating Forecast Length via Dates

Hi again I am using: %history_end_date="2017.09" %forecast_start_date="2017.10" %forecast_end_date="2019.12" To start and label workfiles. I need to be able to get the number of months between %forecast_start_date and %forecast_end_date I don't think datediff can work d...
by BCNAV
Thu Nov 09, 2017 1:50 pm
Forum: Programming
Topic: Adding Titles to Graphs
Replies: 4
Views: 94

Re: Adding Titles to Graphs

Perfect!!

Cheers
by BCNAV
Thu Nov 09, 2017 1:36 pm
Forum: Programming
Topic: Adding Titles to Graphs
Replies: 4
Views: 94

Re: Adding Titles to Graphs

If I have displaynames setup how can I use them in

{%series}_gr.addtext(t) Monthly {%series}
by BCNAV
Thu Nov 09, 2017 12:14 pm
Forum: Programming
Topic: Adding Titles to Graphs
Replies: 4
Views: 94

Adding Titles to Graphs

Hi again, I am using %vars="ovr_ecu_m11 ovr_ecu_m14 ovr_ecu_m22 ovr_ecu_m23 ovr_ecu_ktk ovr_ecu_oth" There are many variables here...just a sample for posting spool a_graphs !count=1 for %series {%vars} freeze(mode=overwrite,{%series}_gr) {%series}_hf.line {%series}_gr.draw(shade, bottom,c...
by BCNAV
Thu Nov 09, 2017 7:27 am
Forum: Programming
Topic: Issue with autoarma and forclen option
Replies: 2
Views: 92

Re: Issue with autoarma and forclen option

thanks..that did it!
by BCNAV
Wed Nov 08, 2017 2:06 pm
Forum: Programming
Topic: Issue with autoarma and forclen option
Replies: 2
Views: 92

Issue with autoarma and forclen option

I have the following code: %m=@left(@date,2) %d=@mid(@date,4,2) !year=2000+@right(@date,2) !annual1=2000 !annual2=2019 wfcreate arima_{!year}.{%m}.{%d} u !annual1 !annual2 %wfsaveloc="R:\Eviews\Workfiles\ARIMA" '------------------------------------------------------------------Start with t...
by BCNAV
Tue Nov 07, 2017 8:26 pm
Forum: Programming
Topic: Custom Fiscal Year
Replies: 3
Views: 142

Re: Custom Fiscal Year

Thank you very much, but eviews will lag the year. Suppose I have: 2000M09 1384532085 2000M10 1358868167 2000M11 1197089389 2000M12 1146904062 2001M01 1166251524 2001M02 1051963506 2001M03 1191344759 2001M04 1241573540 2001M05 1324928884 2001M06 1390336159 2001M07 1486012141 2001M08 1496857895 15436...
by BCNAV
Tue Nov 07, 2017 7:48 am
Forum: Programming
Topic: Custom Fiscal Year
Replies: 3
Views: 142

Custom Fiscal Year

Hi all, Is there a way in EViews to say the fiscal year is September to August? When using our monthly air traffic data I would like to be able to copy that data to the quarterly part of my workfile (separate page) and have it automatically calculate the quarterly totals (which are sums of months) b...
by BCNAV
Tue Oct 31, 2017 10:38 am
Forum: Programming
Topic: WFSAVE Question
Replies: 4
Views: 144

Re: WFSAVE Question

I have tried to no avail....where would they go with the wfsave:

wfsave(2) R:\Traffic Forecasting\EViews\Workfiles\Stochastic\random_walk_{!year}.{%m}.wf1

If I put quotes around the whole thing then _{!year}.{%m} comes out as _{!year}.{%m} and not, say 2017.10

Go to advanced search