export data with no #N/A in blanks

For questions regarding programming in the EViews programming language.

Moderators: EViews Gareth, EViews Jason, EViews Moderator, EViews Matt

chairake
Posts: 9
Joined: Fri Nov 30, 2018 9:31 pm

export data with no #N/A in blanks

Postby chairake » Thu Jan 31, 2019 7:22 pm

Hi,

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


Thank you

Chang

Return to “Programming”

Who is online

Users browsing this forum: No registered users and 27 guests