Search found 21 matches

by PacNW
Thu Jan 26, 2012 12:20 pm
Forum: Econometric Discussions
Topic: Daily Forecasting Model Suggestions
Replies: 0
Views: 2241

Daily Forecasting Model Suggestions

Hi there, I am looking for general help and may be posting in the wrong forum. Please let me know if I should post elsewhere on the site. I am building a daily forecast model of retail sales: The daily sales are impacted by: Day of the Week Day of the Month (the sales are to customers that become mo...
by PacNW
Mon Aug 15, 2011 12:05 pm
Forum: Data Manipulation
Topic: Importing large transposed dataset
Replies: 1
Views: 2211

Importing large transposed dataset

What would be the most efficient way to import a text file data table into EViews that is constructed the following way: 45 columns = weekly dates 78,000 rows = observations of data by a listing ID I'm having trouble with the fact that the data is transposed from the way that is easily readable into...
by PacNW
Tue May 03, 2011 12:42 pm
Forum: Programming
Topic: Removing characters from a predefined string
Replies: 2
Views: 3231

Re: Removing characters from a predefined string

I believe that I have figured it out, you may ignore this thread :D
by PacNW
Tue May 03, 2011 12:37 pm
Forum: Programming
Topic: Removing characters from a predefined string
Replies: 2
Views: 3231

Re: Removing characters from a predefined string

As a followup, I did try and use the @mid function on the current string to create a new string with a new name to use inside the loop, but EViews would not allow me to use the function on the string.
by PacNW
Tue May 03, 2011 12:15 pm
Forum: Programming
Topic: Removing characters from a predefined string
Replies: 2
Views: 3231

Removing characters from a predefined string

Hello, I am using strings to create a vector of variables that are run as separate dependent variables in separate regressions that are restimated and forecast. The problem I am running into is that the variables have a code key at the beginning that must be used in the original string creation. But...
by PacNW
Wed Apr 20, 2011 11:09 am
Forum: Programming
Topic: Step-wise: Exclusion of variables based on sign
Replies: 2
Views: 2512

Re: Step-wise: Exclusion of variables based on sign

Ahh ok, thanks
by PacNW
Wed Apr 20, 2011 10:48 am
Forum: Programming
Topic: Step-wise: Exclusion of variables based on sign
Replies: 2
Views: 2512

Step-wise: Exclusion of variables based on sign

Is there any way to have variables in the step-wise least squares regression be rejected based on sign(+/-) of the estimated variable coefficient?
by PacNW
Mon Apr 11, 2011 8:26 pm
Forum: Programming
Topic: Blanks in input file read as zeros
Replies: 1
Views: 1958

Re: Blanks in input file read as zeros

Oops, figured this one out. Ignore
by PacNW
Mon Apr 11, 2011 8:06 pm
Forum: Programming
Topic: Using strings
Replies: 5
Views: 3984

Re: Using strings

Thank you!
by PacNW
Mon Apr 11, 2011 8:05 pm
Forum: Programming
Topic: Blanks in input file read as zeros
Replies: 1
Views: 1958

Blanks in input file read as zeros

I noticed that EViews is reading blanks from my XLS input file as zeros. Is there any way to have them read in as NA or something that would allow regressions to be run without being biased by the zero values?
by PacNW
Mon Apr 11, 2011 7:11 pm
Forum: Programming
Topic: Using strings
Replies: 5
Views: 3984

Re: Using strings

This appears to work for all of the commands in my program with the exception of the WRITE command. The name of the output xls file ended up including %mystr , possibly because the name of the file was in quotes and enclosed the {%mystr} Is there any way around this? I'd like to write a new csv file...
by PacNW
Mon Apr 11, 2011 2:42 pm
Forum: Programming
Topic: Using strings
Replies: 5
Views: 3984

Re: Using strings

Great, thanks!
by PacNW
Mon Apr 11, 2011 11:27 am
Forum: Programming
Topic: Using strings
Replies: 5
Views: 3984

Using strings

I have a program that uses a specific word string in the options section of wfopen, in the range command in the wfopen line, in the close command, in the wfcreate command, in the group command, in the write command, in the pagesave command, and in the wfsave command For example: wfopen(wf=Alpha) &qu...
by PacNW
Thu Apr 07, 2011 9:10 am
Forum: Programming
Topic: More than 256 columns
Replies: 1
Views: 2621

More than 256 columns

I am working with about 300 series. The input files are xlsx files (with 300 columns) and are being read in correctly using wfcreate. After the EViews program ends, I would like to export the adjusted series to a similar format, i.e. 300 columns, Using the write command with excel, the program runs ...
by PacNW
Wed Apr 06, 2011 7:17 pm
Forum: Programming
Topic: For Loop of Regressions using a wild card
Replies: 8
Views: 6218

Re: For Loop of Regressions using a wild card

Excellent.

Sending code from a phone... whatever you get paid, they should double it.

Go to advanced search