Removing NA values from a series in the workfile

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

[EViews Gareth]

Pagecontract if x<>na

[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

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

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

[EViews Gareth]

What’s the context!?