how to remove #NA when using pagesave to export data from Eviews to excelsheet
Posted: 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?