how to remove #NA when using pagesave to export data from Eviews to excelsheet
Moderators: EViews Gareth, EViews Jason, EViews Steve, EViews Moderator
how to remove #NA when using pagesave to export data from Eviews to excelsheet
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?
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13315
- Joined: Tue Sep 16, 2008 5:38 pm
Re: how to remove #NA when using pagesave to export data from Eviews to excelsheet
Use na="" as an argument to the pagesave command.
Follow us on Twitter @IHSEViews
Who is online
Users browsing this forum: No registered users and 16 guests