how to remove #NA when using pagesave to export data from Eviews to excelsheet

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

yj2283
Posts: 1
Joined: Thu Jul 06, 2017 7:25 am

how to remove #NA when using pagesave to export data from Eviews to excelsheet

Postby yj2283 » Wed Feb 13, 2019 7:44 am

Hi, I am having one issues with pagesave. I need to export data from Eviews to excel sheet using pagesave. But I am seeing #NA instead of blank cells in excel for missing values. I did not see any option in pagesave that allows me to choose NA behavior. The only thing I can do now is to use "replace all" function in excel. It is a bit annoying, because I have to open several large excel files and manipulate them. Can anyone help me out?

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

Re: how to remove #NA when using pagesave to export data from Eviews to excelsheet

Postby EViews Gareth » Wed Feb 13, 2019 8:36 am

Use na="" as an argument to the pagesave command.
Follow us on Twitter @IHSEViews


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 3 guests