Page 1 of 1

regression using variables of different pages

Posted: Mon Nov 28, 2011 1:22 am
by Ydwolf
I have a workfile, consisting of several pages. Now I want to run a regression using variables of different pages, for example, the simple regression: ar01 c smc
Is this possible or should I copy one variable from one page to another?
I have made sure that ar01 and smc have the same sample and range, but if I do copy ar01 to the page that contains the smc-variable, some values appear as "NA"..

Re: regression using variables of different pages

Posted: Tue Nov 29, 2011 2:11 pm
by EViews Gareth
You will need to copy them from one page to another, but there are a few snags:

1) 'year' on the page Ars is a number while 'var01' in the page 'meeste_proxies' is a date. So the first step is to make a variable 'yyyy' in Ars that is a date by

Code: Select all

series yyyy=@makedate(year,"yyyy")
2) Because the variables containing dates aren't called the same thing in the two pages, you need to explicitly name the id series during the copy: otherwise EViews is going to assume that you only want to match on country

3) There are spelling mistakes in the country names in the country series in meeste_proxies: Argentinia, Saoudi Arabia... These have to be fixed before they will be able to be matched.