Search found 168 matches

by tchaithonov
Wed Jul 27, 2016 12:17 pm
Forum: Programming
Topic: WFOPEN function on CSV file changes column data type
Replies: 5
Views: 5607

Re: WFOPEN function on CSV file changes column data type

Yeah, I actually tried both ways

Code: Select all

wfopen(scan=all) {%file} ' which I showed above
wfopen {%file} scan=all


Not working.
by tchaithonov
Wed Jul 27, 2016 11:02 am
Forum: Programming
Topic: WFOPEN function on CSV file changes column data type
Replies: 5
Views: 5607

Re: WFOPEN function on CSV file changes column data type

Hi Gareth,

Thanks for the suggestion, but it doesn't seem to work.

I tried this:

Code: Select all

wfopen(scan=all) {%file}


it seems gives me a series for that column with NAs replacing all the characters.

Am I doing anything wrong with that code? Please let me know. Thanks.

Philip
by tchaithonov
Wed Jul 27, 2016 8:38 am
Forum: Programming
Topic: WFOPEN function on CSV file changes column data type
Replies: 5
Views: 5607

WFOPEN function on CSV file changes column data type

Hi All, I am still using EViews 8.1 and I have this question I don't seem to have a way to solve. I wrote a program that sucks in csv files (panel datasets with date id and cross id columns) into eviews, convert them into dated panel using pagestruct, but before I could do anything, I found out that...
by tchaithonov
Fri Oct 19, 2012 2:29 pm
Forum: Econometric Discussions
Topic: Residuals series used to calculate WLS Standard Errors
Replies: 0
Views: 2592

Residuals series used to calculate WLS Standard Errors

Hi, I am trying to figure out how Eviews calculate the weighted least squares standard errors, and I found out that, by using the residuals from the Actual,Fitted,Residuals Table, the sqrt of the diagonal of the resulting variance-covariance matrix is off by a constant compared to the reported stand...
by tchaithonov
Thu Jul 26, 2012 10:04 am
Forum: Programming
Topic: Subroutine Local
Replies: 3
Views: 4563

Re: Subroutine Local

No ;) Just an example. If you want, call it tab_abc.
by tchaithonov
Thu Jul 26, 2012 7:47 am
Forum: Programming
Topic: Subroutine Local
Replies: 3
Views: 4563

Subroutine Local

Hey there, I am writing a subroutine that requires looking data up from a table. I tried to use "subroutine local" because I don't want the program to store any intermediate elements, but somehow I couldn't make it recognize that the table exists (I just refer to the table "TABLE(!i+1...
by tchaithonov
Wed Apr 04, 2012 5:37 pm
Forum: Programming
Topic: Graph object
Replies: 1
Views: 4022

Graph object

Hey Guys, how are you? I have been writing a program that creates a graph object at first run and check if that object exists (using @isobject()) in subsequent runs, but since I sometimes want to look only at the resid and other times the Dep Var + resid, I run into trouble when trying to show the l...
by tchaithonov
Tue Mar 27, 2012 8:11 am
Forum: Suggestions and Requests
Topic: Shortcut Keys to Add-ins
Replies: 1
Views: 3743

Shortcut Keys to Add-ins

Hi All, I wonder if it's possible to add a shortcut key function for Add-ins into the next generation of eviews. e.g., If you go to Options in the toolbar, you can then click "O" for General Options, "G" for Graphical Defaults. I wonder if there's a way to add this functionality ...
by tchaithonov
Sun Mar 04, 2012 2:52 pm
Forum: Programming
Topic: @Stdev and DB
Replies: 1
Views: 2818

@Stdev and DB

Hi Guys, how are you doing? I am trying to calculate the statistics of a bunch of independent variables located in the DB, and it seems to me that if I do the calculation with variables directly from the database, EViews would give me a "Syntax Error" response. e.g., scalar z = @stdev(abc)...
by tchaithonov
Fri Oct 07, 2011 6:06 pm
Forum: Suggestions and Requests
Topic: Equation Estimation window
Replies: 2
Views: 4193

Re: Equation Estimation window

The dialog box.
by tchaithonov
Fri Oct 07, 2011 11:17 am
Forum: Suggestions and Requests
Topic: Equation Estimation window
Replies: 2
Views: 4193

Equation Estimation window

Hey Guys, Is it possible, in the next version of EViews, to make resizing of the equation estimation window (or "ls") flexible? With live transformation on the variable names, currently I could only see 1 or 2 variables at one time. It would be great if that window could be expanded so tha...
by tchaithonov
Mon Oct 03, 2011 12:43 pm
Forum: Data Manipulation
Topic: Slow Database Refreshing when Workfile Loads
Replies: 4
Views: 5203

Re: Slow Database Refreshing when Workfile Loads

So, I guess, if I don't want the file to open this slowly, I might have to save the data transformations within the groups somewhere else and put them in after the workfile is opened....
by tchaithonov
Mon Oct 03, 2011 12:29 pm
Forum: Data Manipulation
Topic: Slow Database Refreshing when Workfile Loads
Replies: 4
Views: 5203

Re: Slow Database Refreshing when Workfile Loads

Hey Gareth....There are live data transformations within group objects (3,000+ variables), so I guess that's the main reason why it's opening so long. dbopen doesn't take more than 2 secs but Show All takes about a min or so. It's a panel dataset involving 26 cross sections (13,000 data points per v...
by tchaithonov
Mon Oct 03, 2011 9:31 am
Forum: Data Manipulation
Topic: Slow Database Refreshing when Workfile Loads
Replies: 4
Views: 5203

Slow Database Refreshing when Workfile Loads

Hi Guys, A quick question regarding database auto refreshing while workfile that are linked (symbolically, i.e., with a lot of "db::var_abc" in group objects) to the said database is loading. It used to have a pop-up window asking if the user wants to refresh data from the database; lately...
by tchaithonov
Tue Sep 20, 2011 2:02 pm
Forum: Programming
Topic: Statconn (R&Eviews), loops and screen refresh
Replies: 10
Views: 7292

Re: Statconn (R&Eviews), loops and screen refresh

So, I guess the fastest way would be to minimize the number of transactions between R and Eviews then... which means I need to make R understands panel data correctly .... alrighty, thanks Gareth!

Go to advanced search