Transposing data when saving to foreign file

For requesting general information about EViews, sharing your own tips and tricks, and information on EViews training or guides.

Moderators: EViews Gareth, EViews Moderator

MartinsFest
Posts: 27
Joined: Tue Dec 13, 2022 4:41 am

Transposing data when saving to foreign file

Postby MartinsFest » Tue Mar 21, 2023 4:38 am

Hello,

When saving a workfile, I would like to have the dates be columns instead of rows, like below:

Image

It's preferable that this is done within Eviews, as this will be a program running on a server which periodically gives us new datasets.

Any tips are received with great thanks.

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

Re: Transposing data when saving to foreign file

Postby EViews Gareth » Tue Mar 21, 2023 7:23 am

Assuming you want to save to Excel:

Code: Select all

wfsave(type=excelxml) c:/temp/myfile.xlsx byrow
Follow us on Twitter @IHSEViews


Return to “General Information and Tips and Tricks”

Who is online

Users browsing this forum: No registered users and 23 guests