Page 3 of 3
Re: Removing NA values from a series in the workfile
Posted: Tue Apr 01, 2014 11:49 am
by misscats
Yes, both the wfopen and import commands have a range statement to select the range of cells to import.
Many many thanks. But back to my initial question: how to write the code for the below action?
Proc->Contract Current Page
then set the sample to "if X<>NA" where X is the series with the NAs.
Re: Removing NA values from a series in the workfile
Posted: Tue Apr 01, 2014 11:57 am
by EViews Gareth
Pagecontract if x<>na
Re: Removing NA values from a series in the workfile
Posted: Wed Apr 02, 2014 3:49 am
by misscats
Pagecontract if x<>na
Thank you Gareth. Thanks for inspiring me. I also try to code in a different way and it also works:
Code: Select all
for %sheet 1 2 3
%range = %sheet
wfopen "C:\Users\...\Data.xlsx" range=%range @keep smb hml mom dummy1 ret @selectif ret<>na
next
Re: Removing NA values from a series in the workfile
Posted: Sat May 24, 2014 3:37 am
by vasudhak
Hello,
I am using Eviews 7, I am an amateur. I have stock return series of 45 companies in 5-day per week format over 150 days. I want to establish there GARCH model, but Eviews prompt me saying that we cannot run MA models on discontinuous series.
I have some NA values in my stock return series, some are missing data and other are government holidays. Can you please suggest how to deal with these NA values and establish GARCH model hence.
Re: Removing NA values from a series in the workfile
Posted: Wed May 05, 2021 4:08 pm
by Hammedm
Hi all,
@all if y<>na, is bring error (@ALL is not defined or an illegal command in eviews 11). Could you help pls.
Thank you.
Re: Removing NA values from a series in the workfile
Posted: Wed May 05, 2021 4:17 pm
by EViews Gareth
What’s the context!?