creating weekly and semi annual dummies with @expand

[ray2013]

thank you guys. it worked.

[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

[EViews Gareth]

Code: Select all

series newnumb=@val(alpha01)

Should work.

[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

[EViews Gareth]

There's probably some non-numerical characters in that alpha series then.

[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    

[startz]

A space in the middle would be the non-numeric character Gareth alluded to.

[ray2013]

thanks guys. i guess i better remove the spaces in the data from excel before i import it

[startz]

It is possible that something like the following will work in EViews.

Code: Select all

series numeric=@val(@replace(alpha02," ",""))

[ray2013]

i tried it and it still gives NA

[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.

[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)

[EViews Gareth]

http://forums.eviews.com/viewtopic.php?f=5&t=1638

[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

[EViews Gareth]

Other than by doing a screenshot, you cannot.