EViews.com

Hello, I have to export data from a workfile to an excel file with 120 different tabs. I am wondering if there is a way to put a loop on within the "range" specification, specifically to loop through the excel sheet number. It doesn't seem to be working for me. For example: for !i=1 to 120...

Thanks! That seem to work. I also found an alternative solution from a previous forum post, which uses a temporary matrix: matrix (89,2) looptemp looptemp.fill 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50...

Hello, I have the following code: for !j=1 to 89 for !i=0 to 88 for %g f m series nm{%g}{!j} nm{%g}{!j}=p{%g}{!j}-(p{%g}{!i}(-1)-d{%g}{!j}) nm{%g}{!j}.setformat f.0 next next next As it runs now, the !i loop is treated as nested, however I want both the !i and !j loops to run simultaneously. Is ther...

Hello, I am wondering if there is any way to write or save a matrix to a pre-formatted excel file, while specifying what sheet to write/save to within the excel file. I could be wrong, but I don't think the "write" command allows you to write to a pre-formatted excel file. I have also trie...

Hello, I have roughly 8,600 different series that I want to use to form a matrix. I have been looking at the "stom" command, however it requires you list each series you want to put into the matrix. Obviously I want to avoid listing 8,600 series. I have also explored the option of creating...

Worked perfectly. Thanks!

Hello, I think this is a simple request... I want to create an index series called "index" within EViews with 48 observations, numbered 1 to 48 spanning from 1986 to 2036 So: 1986 = 1 1987 = 2 1988 = 3 . . . 2036 = 48 Can't seem to figure out a simple way to do this. Hope you can help. Tha...

Nice, thank you very much!

Sure.

See attached

Hello, I have a rate calculated for the year 2012, and population projections for the years 2012-2036. I want to multiply the rate for 2012 by the population each year from 2012-2036. Currently my code is only multiplying the rate from 2012 by the population from 2012 and giving me NA for the rest o...

Hi, I have a workfile with two separate pages. The first page is called "LTC" and the second page is called "POP". The LTC page contains counts by age and sex of long-term care residents for 2012. The POP page contains a time-series of population data by age and sex for the years...

Ok thanks. But just so you guys are aware, in the EViews 8 Beta Documentation examples under "wfsave", it is the other way around. The example is provided like this:

Using EViews 8 Beta, I am trying to export data from a workfile to an exisiting Excel file using the following commands: for %a 0to4 5to9 10to14 15to19 20to24 25to29 30to34 35to39 40to44 45to49 50to54 55to59 60to64 65to69 70to74 75to79 80to84 85to89 90plus wfsave(type=excelxml, mode=update) range=&q...

Ouch.

Gonna have to upgrade to Version 8 I guess haha

Thanks again man i appreciate all the help

Sorry I didn't notice the 8.

So there is no way to do this in Version 7?