I have a little trouble about exporting data from eviews work-file to excel because there are
#N/A in blanks event I command to avoid the case. How can I adapt my code to delete #N/A in my blank cell.
This is my code (I understand that na= blank is a key to solve my problem. However, after I try such as na= ' ', na = " ". It didn,t work. )
wfsave(type=excelxml , na= blank) "e:\documents\++++material forecast\4 mat forecast result keep\Forecast\forecast as of 2019m1.xlsm" @keep YEAR_MONTH AREA MATERIAL Q QF Q_GROWTH Q_GROWTHF Q_MA3_GROWTH Q_MA3_GROWTHF Q_MA3_TREND_GROWTH Q_MA3_TREND_GROWTHF LEADING1 LEADING2 LEADING3
For questions regarding programming in the EViews programming language.
1 post • Page 1 of 1
Who is online
Users browsing this forum: No registered users and 5 guests