Changing variable names when writing to excel

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

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

Posts: 26
Joined: Wed Feb 28, 2018 8:02 pm

Changing variable names when writing to excel

Postby statsforecast » Tue Aug 14, 2018 11:05 am

Hello there! I am trying to change the variables names in a group of series when writing to excel. I usually have something like this:

write(e,noid) "filepath" DATE group01

I would like to perform something like @mid(group01.@members, 3,8) to each series name in group01 when outputting to excel. What I am trying to do basically is to fetch the original series names which were numerical (8 digits), and strip them from the alpha characters that Eviews adds to make the series names valid and the character f at the end of the forecast series.

I would appreciate any ideas.

Thank you.

Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 3 guests