Search found 23 matches

by ral
Thu May 05, 2016 3:43 pm
Forum: Programming
Topic: Andrews-Quandt breakpoint test
Replies: 1
Views: 2682

Andrews-Quandt breakpoint test

Hi, I would like to run an Andrews-Quandt test for an unknown breakpoint. Here is the equation I am estimating: equation eqylda.ls(cov="hac") (us10y-us2y) c ahemomstd nfpstd ubreak 15 I estimate the equation without a problem, but I get this error when I try to run the A-Q test: UBREAK is ...
by ral
Fri Feb 19, 2016 12:39 pm
Forum: Programming
Topic: Matrix with NAs
Replies: 4
Views: 3756

Re: Matrix with NAs

Thank you, Gareth. Boneheaded error on my part.

Ron
by ral
Fri Feb 19, 2016 12:29 pm
Forum: Programming
Topic: Matrix with NAs
Replies: 4
Views: 3756

Re: Matrix with NAs

Thanks, Gareth. This line pricesmat(T,!j) = subcomp{!j}_v was supposed to replace each of the j=1,...,N columns with the j=1,...,N series, but that appears to be the source of the error. After I sent the email, I remembered the colplace command and modified the loop, but I still get an error message...
by ral
Fri Feb 19, 2016 11:58 am
Forum: Programming
Topic: Matrix with NAs
Replies: 4
Views: 3756

Matrix with NAs

Hi, I would like to produce a TxN matrix from a set of N individual series. The issue is that there are time periods with NAs in each of the series. I want to keep track of the NAs in the matrix. To solve the problem, I tried two possibilities (below), but neither worked. The output is a TxN matrix ...
by ral
Wed May 06, 2015 1:56 pm
Forum: Data Manipulation
Topic: Numeric operator and string data
Replies: 5
Views: 6360

Re: Numeric operator and string data

I solved the problem. My program worked for some countries but not others, and there did not appear to be a systematic pattern governing when it did not work. The issue may have something to do with Excel rather than Eviews. I inserted this logical test into the cells from which I was loading the da...
by ral
Wed May 06, 2015 9:08 am
Forum: Data Manipulation
Topic: Numeric operator and string data
Replies: 5
Views: 6360

Re: Numeric operator and string data

I replaced this line in the program: import(type=excelxml) {%excelname} range={%x}_eviews @freq m %start with this line: import(type=excelxml) {%excelname} range={%x}_eviews types=(w, w, w, w, w, w,w, f, w, w) @freq m %start I get this error now: Syntax error: invalid format string in "IMPORT(T...
by ral
Wed May 06, 2015 8:48 am
Forum: Data Manipulation
Topic: Numeric operator and string data
Replies: 5
Views: 6360

Re: Numeric operator and string data

Thank you for the quick reply. I get an error with the @val function: Numeric argument passed to string @VAL function in "SERIES PMI1=@VAL(PMI) This presumably happens because there are non-missing numerical data included in the series. The Excel spreadsheet and the program are attached. The re...
by ral
Wed May 06, 2015 8:10 am
Forum: Data Manipulation
Topic: Numeric operator and string data
Replies: 5
Views: 6360

Numeric operator and string data

Hi, I am running a program that loads data into Eviews country by country and computes indices using the data. I added a series (PMI) that uses #N/A N/A to indicate missing values. The program works fine for one country (the United States), but I get the error message: Numeric operator applied to st...
by ral
Fri Apr 24, 2015 5:09 am
Forum: Programming
Topic: Modifying graphs in a loop
Replies: 1
Views: 2463

Modifying graphs in a loop

I am creating a set of graphs in a loop that iterates over a set of countries. I would like to change the line width in each of the graphs to make them more legible. Below is a code fragment that works. I tried inserting caicomp_{%x}.setelem(1) lwidth(2) into the loop below to increase the width of ...
by ral
Mon Mar 30, 2015 2:38 pm
Forum: Programming
Topic: Scenario analysis
Replies: 1
Views: 2363

Scenario analysis

Hi, I have a forecasting model y(t+1) = a + b*y(t) + c*x(t) + e(t+1) and want to automate as much as possible inserting alternative paths for y(t) and x(t) to do scenario analyses. For example, I want to exogenously set y(t+h) and x(t+h), h > 1, equal to some values to see what the model predicts ab...
by ral
Tue Feb 24, 2015 9:07 am
Forum: Programming
Topic: Assigning string variable to matrix element
Replies: 2
Views: 2934

Assigning string variable to matrix element

Hi, Is it possible to assign a string variable to an element in a matrix? The code fragment that I have written is below. I would like the output to be a 7xN matrix (N=2 in the fragment below) where the top row contains the names of the variables in the group (i.e., EURUSD and USDJPY) and the rows o...
by ral
Tue Feb 10, 2015 12:41 pm
Forum: Data Manipulation
Topic: Exporting data to Excel
Replies: 13
Views: 15385

Re: Exporting data to Excel

It works for me now, too. I rebooted my computer. Thanks.
by ral
Tue Feb 10, 2015 11:53 am
Forum: Data Manipulation
Topic: Exporting data to Excel
Replies: 13
Views: 15385

Re: Exporting data to Excel

In the program I just sent you, there is a code fragment based on a change I am making to the program. (It is unrelated to the problem I am having.) The attached file removes it. Apologies.
by ral
Tue Feb 10, 2015 11:48 am
Forum: Data Manipulation
Topic: Exporting data to Excel
Replies: 13
Views: 15385

Re: Exporting data to Excel

Here is the program and the workfile. Thank you for your time, Gareth.

Ron
by ral
Tue Feb 10, 2015 11:34 am
Forum: Data Manipulation
Topic: Exporting data to Excel
Replies: 13
Views: 15385

Re: Exporting data to Excel

Hi, Something is still not working right. I get the same error message as before after modifying the program in the way that you suggested: wfsave(type= excelxml ,mode=update) "p:\requests\cli\cli.xlsx" range=%range @smpl %start %end @keep clioutput_{%x} When I run this command outside of ...

Go to advanced search