pageupdate on Excel - dates / smpl options

For questions regarding the import, export and manipulation of data in EViews, including graphing and basic statistics.

Moderators: EViews Gareth, EViews Steve, EViews Moderator, EViews Jason

loulouviews
Posts: 60
Joined: Wed Mar 11, 2015 2:19 am

pageupdate on Excel - dates / smpl options

Postby loulouviews » Mon Apr 04, 2016 3:03 am

Hi,

I'm willing to update an excel sheet with new data.
I have two questions :
- How can I have EViews writing dates as in the `write` command, ie "1990M01" instead of 32874.
- How can I restrict the sample ? writing something like `smpl 2014 2016`before the `pagesave` command is unfortunately not working (where as working like a charm for the `write` command).

Thanks

Loulouviews

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13602
Joined: Tue Sep 16, 2008 5:38 pm

Re: pageupdate on Excel - dates / smpl options

Postby EViews Gareth » Mon Apr 04, 2016 7:19 am

If you want the dates written in a specific string format rather than as an Excel date, you'll have to create an alpha series with that string format using the @datestr command.

The wfsave command has an @smpl argument that lets you specify the sample.


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 2 guests