Page 2 of 3
Re: creating weekly and semi annual dummies with @expand
Posted: Tue Oct 29, 2013 12:52 am
by ray2013
thank you guys. it worked.
Re: creating weekly and semi annual dummies with @expand
Posted: Tue Nov 12, 2013 7:43 am
by ray2013
i copied a set of data from excel cells into my empty worksheet.my data contained numbers. it pasted the data into my worksheet as alpha01.
so i presume they are in strings. how do i convert this to numbers and generate a series from my data.
i tried
series newnumb=@val(alpha01) and it doesnt work
can i get some help
Re: creating weekly and semi annual dummies with @expand
Posted: Tue Nov 12, 2013 9:22 am
by EViews Gareth
Re: creating weekly and semi annual dummies with @expand
Posted: Tue Nov 12, 2013 10:40 am
by ray2013
it gives me NA as the inputs
also when i imported that same data from excel to eviews it was giving me NA in the cells. But when i copy and paste it,i get my data on eviews in a group with name as alpha01
but series newnumber=@val(alpha01) gives me NA in the cells
Re: creating weekly and semi annual dummies with @expand
Posted: Tue Nov 12, 2013 10:41 am
by EViews Gareth
There's probably some non-numerical characters in that alpha series then.
Re: creating weekly and semi annual dummies with @expand
Posted: Tue Nov 12, 2013 10:59 am
by ray2013
my alpha02 values i copied from excel appear in eviews as follows and its left aligned
6 876
7 194
7 481
7 359
8 316
it doesnt appear as
6876
7194
7481
7359
8316
Re: creating weekly and semi annual dummies with @expand
Posted: Tue Nov 12, 2013 11:01 am
by startz
A space in the middle would be the non-numeric character Gareth alluded to.
Re: creating weekly and semi annual dummies with @expand
Posted: Tue Nov 12, 2013 11:08 am
by ray2013
thanks guys. i guess i better remove the spaces in the data from excel before i import it
Re: creating weekly and semi annual dummies with @expand
Posted: Tue Nov 12, 2013 11:33 am
by startz
It is possible that something like the following will work in EViews.
Code: Select all
series numeric=@val(@replace(alpha02," ",""))
Re: creating weekly and semi annual dummies with @expand
Posted: Tue Nov 12, 2013 12:10 pm
by ray2013
i tried it and it still gives NA
Re: creating weekly and semi annual dummies with @expand
Posted: Tue Nov 12, 2013 12:11 pm
by startz
i tried it and it still gives NA
Probably back to Excel then. But just to be sure, the code requires no spaces between the last set of quotes.
Re: creating weekly and semi annual dummies with @expand
Posted: Sat Nov 30, 2013 11:46 am
by ray2013
is it possible to generate a table of AIC values for my
equations
equation arma01.ls y c ma(1)
equation arma02.ls y c ma(1) ma(2)
equation arma03.ls y c ma(1) ma(2) ma(3)
equation arma10.ls y c ar(1)
equation arma11.ls y c ar(1) ma(1)
equation arma12.ls y c ar(1) ma(1) ma(2)
to
equation arma33.ls y c ar(1) ar(2) ar(3) ma(1) ma(2) ma(3)
Re: creating weekly and semi annual dummies with @expand
Posted: Sat Nov 30, 2013 11:51 am
by EViews Gareth
Re: creating weekly and semi annual dummies with @expand
Posted: Tue Dec 24, 2013 2:55 am
by ray2013
when i copy the correlogram graph into msword, it doesnt show the bars of the ACF AND PACF but it shows it as " * ".
how do i copy it into microsoft word for it to show the bars of the ACF and PACF
Re: creating weekly and semi annual dummies with @expand
Posted: Tue Dec 24, 2013 8:27 am
by EViews Gareth
Other than by doing a screenshot, you cannot.