Search found 14 matches

by mikela
Fri Nov 06, 2015 7:37 am
Forum: Estimation
Topic: ROC curve
Replies: 23
Views: 36263

Re: ROC curve

Hi
is it possible to automate step 2. Ie, execute the test for equality by classification in the program and saving the test results rather than writing it down by hand?
I can't find the command to run the test.

Many thanks,
Mikela
by mikela
Wed Mar 11, 2015 4:07 am
Forum: General Information and Tips and Tricks
Topic: How to enter data into a panel workfile.
Replies: 225
Views: 928875

Re: How to enter data into a panel workfile.

Hi, i've looked through this thread but i can't find a way to use any of the programs to import my data from excel and stack them in eviews. i attach the excel file, there are 230 cross sections, and 10 variables across 9 years (but some sheets will have less years). Is there a way i can import them...
by mikela
Tue Mar 10, 2015 1:57 am
Forum: Programming
Topic: stack data from excel
Replies: 1
Views: 3483

stack data from excel

hi, i have a lot of data in excel format, in each sheet one variable across 230 individuals, for 82 variables (so 82 sheets). I need to reshape these data into one big panel, stacking the data. Currently i'm trying to use pagestack but i don't manage to make it work. So here is what i am doing: firs...
by mikela
Wed Dec 17, 2014 9:08 am
Forum: Programming
Topic: importing panel data from excel
Replies: 7
Views: 10318

Re: importing panel data from excel

i tried, but with import i still get an error message regarding the ids somehow...

Actually it also works by using only pageload recursively without opening or i shall say loading a workfile first, it just adds pages to the new workfile created by pageload.
by mikela
Wed Dec 17, 2014 9:05 am
Forum: Programming
Topic: importing panel data from excel
Replies: 7
Views: 10318

Re: importing panel data from excel

i've got it! i have to use first

wfload "myworkfile"

and then

pageload(page=AU).....

and it adds pages to myworkfile!

thanks anyway!

michela
by mikela
Wed Dec 17, 2014 8:56 am
Forum: Programming
Topic: importing panel data from excel
Replies: 7
Views: 10318

Re: importing panel data from excel

now i found an interim solution but I really don't understand the logic of eviews in creating a workfile and opening a workfile. Why do you have two commands wfcreate and wfopen, it's just not clear (even though i see they are different commands). Anyway, if i use the following command: wfopen(page=...
by mikela
Tue Dec 16, 2014 1:35 am
Forum: Programming
Topic: importing panel data from excel
Replies: 7
Views: 10318

Re: importing panel data from excel

my copy is Eviews 8, 64-bit, Jun 19 2013 build (not sure this is the latest). i don't have a workfile as i create it in the program, so i'm basically running these two lines in my program wfcreate(wf=australia) y 1999 2014 import L:\DRS\Users\MichelaS\Bankscope\byCountry\AU\panelTest.xlsx range=&quo...
by mikela
Mon Dec 15, 2014 7:37 am
Forum: Programming
Topic: importing panel data from excel
Replies: 7
Views: 10318

importing panel data from excel

hi, i'm trying to write the command line to import a file structured like the excel here. i have two questions: 1) what type of workfile i need to create before using the import command (assuming i shall be using import), for now i'm using an annual workfile, but not sure it's right 2) when i try so...
by mikela
Thu Aug 25, 2011 2:34 am
Forum: Data Manipulation
Topic: stacked bar plus line graph
Replies: 26
Views: 99224

stacked bar plus line graph

hi everyone, i am not sure how to make the following chart. I have three series a,b,c and i would like to have in one graph a stacked bar of [a,b] with left-hand scale and a line graph of [c] on the right-hand scale. is this possible? i managed to have the stacked bars and line but i can't different...
by mikela
Tue Aug 02, 2011 8:31 am
Forum: General Information and Tips and Tricks
Topic: eviews vs. stata
Replies: 1
Views: 17660

eviews vs. stata

dear all, i have a general question regarding the usage and advantages of eviews vs. stata. I work in the research department of a financial institution and I've been asked by my boss to write a memo summarizing the features of each software in order to reach a decision as to whether we should keep ...
by mikela
Wed Jan 19, 2011 2:07 am
Forum: Programming
Topic: Counting dates between observations
Replies: 6
Views: 9038

Re: Counting dates between observations

thanks! i was struggling with cumsum (because it continue to cumulate regardless of the missing values) but with this code was much easier, thanks again!
by mikela
Tue Jan 18, 2011 6:07 am
Forum: Programming
Topic: Counting dates between observations
Replies: 6
Views: 9038

Counting dates between observations

Hi everyone, I have a simple but tedious problem to solve and i am starting to feel desperate... I have lots of times series (annual data from 1900-2011) with lots of #NAs in them. What i need to do is to produce a table with the number of years between observations. Is there an easy way to do this ...
by mikela
Tue Jan 11, 2011 10:24 am
Forum: Programming
Topic: Peak and trough dates
Replies: 3
Views: 6358

Re: Peak and trough dates

I think that will do, it was so easy!
thanks a LOT!
m.
by mikela
Tue Jan 11, 2011 8:35 am
Forum: Programming
Topic: Peak and trough dates
Replies: 3
Views: 6358

Peak and trough dates

Hi everyone, I am trying to find a procedure to find peaks and troughs dates in a time series with eviews. It should be something like the Bry and Boschan routine which i found but only in Rats and it would take me quite a bit of time to reproduce in eviews. Has anyone already dealt with this proble...

Go to advanced search