Page 1 of 1

@keep vs @drop

Posted: Fri Jul 03, 2015 1:21 pm
by ian.e.preston
I'm trying to export a series to an excel file.
pagesave(t="excelxml") %file_out @keep x
creates an excel file with a date column and a series with a header that says "X" and then a whole series that is just X over and over
if I do pagesave(t="excelxml") %file_out @drop x2
it works as I'd expect, outputting all series except x2 with their numerical values. It really seems to be an issue with @keep.
I can workaround this issue by just dropping every other series, but given that I only want to export one series that's cumbersome. Any ideas what's causing this?
I'm using eviews 9

Re: @keep vs @drop

Posted: Fri Jul 03, 2015 2:14 pm
by EViews Gareth
Could you provide the workfile?

Re: @keep vs @drop

Posted: Fri Jul 03, 2015 2:16 pm
by ian.e.preston
Sure. I've also attached the program I'm using
Right now it's using drop, which as you can see is cumbersome.

Re: @keep vs @drop

Posted: Fri Jul 03, 2015 2:45 pm
by EViews Gareth
which series are you trying to @keep?

Re: @keep vs @drop

Posted: Mon Jul 06, 2015 6:33 am
by ian.e.preston
lmi_t, but the issue is the same with whatever series I try.

Re: @keep vs @drop

Posted: Mon Jul 06, 2015 8:26 am
by EViews Gareth
What's the build date of your copy of EViews 9? (Help->About EViews).

Re: @keep vs @drop

Posted: Mon Jul 06, 2015 8:30 am
by ian.e.preston
April 20 2015.

Re: @keep vs @drop

Posted: Mon Jul 06, 2015 8:47 am
by EViews Gareth
Very out of date. Please update to the latest version.