There are a large number of series involved, so when saving and fetching to the database, I just have the * to save/fetch all series.
As I noted, before this was never an issue.
Search found 17 matches
- Mon Jan 14, 2013 9:08 am
- Forum: Data Manipulation
- Topic: Database and "Resid"Issues
- Replies: 3
- Views: 3928
- Mon Jan 14, 2013 8:17 am
- Forum: Data Manipulation
- Topic: Database and "Resid"Issues
- Replies: 3
- Views: 3928
Database and "Resid"Issues
A number of months ago, I wrote a couple of programs. One of the program pulled some data from a number of sources, did some adjustments and saved it into a database, adjusting for a specific frequency. The second program pulled the data from this database and that where I completed some estimation ...
- Wed Sep 05, 2012 10:59 am
- Forum: Estimation
- Topic: ECM Examples
- Replies: 1
- Views: 2622
ECM Examples
I'm about to embark on a project that requires using an ECM. I've never applied this methodology using EViews before and I'm wondering if there's an example of how to develop and ECM that someone may be able to point me to? Also, if there's an example of how to input an ECM using the EViews programm...
- Thu Jul 26, 2012 12:58 pm
- Forum: Programming
- Topic: Programming/ Setting Value for Coefficients
- Replies: 2
- Views: 4112
Programming/ Setting Value for Coefficients
I'm wondering if there's a way to set/force a coefficient to take on a specific value. For example, is there way to set the following when I'm programming so that c(2) = -0.15 and that carries into the estimation and the output? LOG(TSEC ) = C(1) + C(2)*LOG(DIESEL)+C(3)*(POP) + C(4)*LOG(gdp)+ C(5)*D...
- Fri Jul 20, 2012 1:16 pm
- Forum: Econometric Discussions
- Topic: Forecasting with LDV, AR(1) and Seasonal Dummies
- Replies: 0
- Views: 2152
Forecasting with LDV, AR(1) and Seasonal Dummies
I've built a model that has really strong explanatory power, a good fit and very reasonable (and significant) coefficients. All of this has been developed using pooled least squares. Included among the explanatory variables are an AR(1) term, 3 quarterly dummies, the constant and a lagged dependent ...
- Tue Jul 17, 2012 11:41 am
- Forum: Programming
- Topic: Replace NA by 0
- Replies: 5
- Views: 14552
Re: Replace NA by 0
I got a number of series where I have this same problem and I've tried the recode approach as below and it hasn't worked. I'm still left with NA's in the series and it's throwing things off for me.
What have I got wrong in the programming?
Code: Select all
Nonwork=@recode(na,0,0)- Tue Jul 10, 2012 6:17 am
- Forum: Programming
- Topic: Loop Programming and Estimation
- Replies: 2
- Views: 3345
Re: Loop Programming and Estimation
Thanks for the reply.
I've been reading through some of the programming threads and making notes as I'm going. Just hadn't seen case before.
I've been reading through some of the programming threads and making notes as I'm going. Just hadn't seen case before.
- Tue Jul 10, 2012 5:47 am
- Forum: Programming
- Topic: Loop Programming and Estimation
- Replies: 2
- Views: 3345
Loop Programming and Estimation
I've got a number of variables with similar names that I'd like estimate in a similar manner. For each variable the naming memnomic take the form of: CA_12_POP where: -"CA" is the country. In this case it's Canada, but I've also go US, UK, FR -"12" is the province/state/region -&...
- Tue Jul 03, 2012 10:18 am
- Forum: Data Manipulation
- Topic: Importing Data from Excel
- Replies: 1
- Views: 2959
Importing Data from Excel
Hello, I have a question regarding importing data from excel that I'm hoping someone can help me with. When I'm writing a program and I have an excel file with data on multiple sheets that I need to import, what should it the code be? For example, what options should I put to ensure that I get the a...
- Fri Apr 20, 2012 6:52 am
- Forum: Programming
- Topic: Programming Data Merging
- Replies: 1
- Views: 2812
Programming Data Merging
I've got an existing database and for one of the programs I've written, I'm truing to import new data for some of the variables from an excel file. However, I can't figure out how to program that so the final series I end up with is merger of the database series and the excel file series. I'm not su...
- Mon Mar 19, 2012 10:19 am
- Forum: Programming
- Topic: System of Equations Forecasting
- Replies: 3
- Views: 4893
Re: System of Equations Forecasting
Using that command, how would I name the specific model that I'm creating?
- Mon Mar 19, 2012 8:44 am
- Forum: Programming
- Topic: System of Equations Forecasting
- Replies: 3
- Views: 4893
System of Equations Forecasting
Hello, I’m trying to write a forecasting program and model and one of the objects in that will need to be incorporated is a seemingly unrelated equation system. I’ve got the system written into my program: system atl atl.append log(rtddnl) = c(1) + c(2)*log(repnl)+c(3)*log(popnl)+c(4)*log(hddnl) atl...
- Wed Mar 14, 2012 7:04 am
- Forum: Estimation
- Topic: Seemingly Unrelated Regression
- Replies: 9
- Views: 12952
Re: Seemingly Unrelated Regression
Gah. I'd missed that typo in the programming.
Thanks.
Thanks.
- Wed Mar 14, 2012 6:49 am
- Forum: Estimation
- Topic: Seemingly Unrelated Regression
- Replies: 9
- Views: 12952
Re: Seemingly Unrelated Regression
The equations when estimated using LS work.
- Wed Mar 14, 2012 6:34 am
- Forum: Estimation
- Topic: Seemingly Unrelated Regression
- Replies: 9
- Views: 12952
Seemingly Unrelated Regression
Hello, I'm trying to estimate the following using the seemingly unrelated equations methodology but I get an error, near singular matrix prompt. What's the cause of this and how can I adjust the programming to ensure that this doesn't occur? LOG(RTDDPE) = C(1) + C(2)*LOG(REPNL)+C(3)*LOG(POPNL)+C(4)*...
