Changing variable names when writing to excel
Posted: 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.
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.