Handling NA values

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

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

contango
Posts: 1
Joined: Wed Jun 17, 2015 3:06 am

Handling NA values

Postby contango » Wed Jun 17, 2015 3:15 am

I'm tring to create a returns series from a price time series. The problem I have is that there is are NA values on bankholidays (e.g. a Monday). Therefore when I use @pca(ftse100) on that series it results in TWO NA values (for the Monday and the Tuesday) rather than completely ignoring it. There must be a way that @pca and @pch etc can skip over NA values completely.

BTW as you have probably guessed I'm completely new to eViews!

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13603
Joined: Tue Sep 16, 2008 5:38 pm

Re: Handling NA values

Postby EViews Gareth » Wed Jun 17, 2015 11:26 am

Remove those dates from the workfile.

From the workfile click on proc->contract current page, then enter the sample as "if X<>na" where X is the name of your returns series.


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 2 guests