Removing NA values from a series in the workfile

For questions regarding the import, export and manipulation of data in EViews, including graphing and basic statistics.

Moderators: EViews Gareth, EViews Jason, EViews Steve, EViews Moderator

misscats
Posts: 29
Joined: Wed Mar 19, 2014 8:37 am

Re: Removing NA values from a series in the workfile

Postby misscats » Tue Apr 01, 2014 11:49 am

EViews Gareth wrote: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
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13294
Joined: Tue Sep 16, 2008 5:38 pm

Re: Removing NA values from a series in the workfile

Postby EViews Gareth » Tue Apr 01, 2014 11:57 am

Pagecontract if x<>na
Follow us on Twitter @IHSEViews

misscats
Posts: 29
Joined: Wed Mar 19, 2014 8:37 am

Re: Removing NA values from a series in the workfile

Postby misscats » Wed Apr 02, 2014 3:49 am

EViews Gareth wrote: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
Posts: 4
Joined: Sat May 24, 2014 3:27 am

Re: Removing NA values from a series in the workfile

Postby vasudhak » Sat May 24, 2014 3:37 am

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
Posts: 2
Joined: Thu Apr 29, 2021 8:04 pm

Re: Removing NA values from a series in the workfile

Postby Hammedm » Wed May 05, 2021 4:08 pm

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
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13294
Joined: Tue Sep 16, 2008 5:38 pm

Re: Removing NA values from a series in the workfile

Postby EViews Gareth » Wed May 05, 2021 4:17 pm

What’s the context!?
Follow us on Twitter @IHSEViews


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 8 guests