EViews.com

I found this on a previous answer you provided. Does this delete objects with ONLY #N/As.

group g*
for !i=1 to g.@count
%name = g.@seriesname(!i)
if @obs({%name}) = 0 then
d {%name}
endif
next

Below is the code I use. When I run the series avg_{%h}_bs_{%i} command below it also tries to do this for the second tab (resulting in an error) where it obviously can't find the _bs_ as they are only on the first page. wfcreate(wf=semi-annual) s 1990 2017 %mypath = @runpath cd %mypath 'loads first...

Also wondering how I would delete all series that have ONLY #N/A's in them. I found some posts about deleting series' with #N/A but this applies to series' with any #N/As

Thank you and happy Friday 13th

Hi Glen and Gareth, I am working on a program and am trying to figure out how to specify a loop command for a particular worksheet in Eviews. I load in 2 excel worksheets from the same workbook which become separate Eviews tabs. Howver, when I try to execute a loop it does it to both tabs in the EVi...

Thanks, Glen

I've changed that but I still get that my first variable is undefined. Any ideas?

The error I keep getting is AVG_("BS_cash") is not defined in "SERIES AVG = AVG_("BS_CASH") / ("BS_OBSCASH")".

so for each variable, for instance BS_cash there are different "Sectors" CONS_DISC_ CONS_STAP_ ENERGY_ FIN_ HEALTH_ INDUST_ IT_ MAT_ TELECOM_ UTILITIES_ TOT_ TOTEXFIN_ TOTEXENERGY_ TOTEXFIN&ENERGY_ does this mean I need to list out each with "Sector"_BS_Cash ? for %j and &quo...

Correct, but it needs to be a loop

because BS_cash needs to be divided by BS_obscash, BS_acctrec needs to be divided by BS_obsacctrec etc etc.

Thanks.

So I only have the total imported in and then separately the number of observations so I can't use that function as I don't have the individual observations making up the total. Thanks.

Ah yes, thanks Jason. One other question. I am trying to create a new variable which is an average of total sum of all observations divided by the number of observations. I think I need to create a loop in Eviews, can you help me? If I have 4 variables BS_cash and BS_acctrec and BS_obscash and BS_ob...

Thanks, Gareth I have tried the following: wfcreate(wf=semi-annual, page = "BSStoxx600") s 1990 2017 %mypath = @runpath cd %mypath import Stoxx600_BSdata.xlsx byrow range="EViews" @freq s 1990s1 for %y BS_Cash BS_obscash group g_{%y} for %z Cons_Dis Cons_Stap Energy Fin Health In...

Hi Gareth, I have the attached file and am looking to write a program that inputs the data from excel into Eviews. The data needs to be transposed, however, as the dates are horizontally across rather than vertically down the page. I am also looking to group these variables by BS_cash, BS_obscash, B...

Hi Gareth, In the example you give below is it possible then to isolate a variable, say history of house prices in Alabama? If you open up the object house prices, the house prices appear for all the states. What if I just wanted to regress house prices in Alabama against the school budget in Alabam...