Unstacking data

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

leocaza
Posts: 18
Joined: Mon Nov 27, 2017 7:18 am

Unstacking data

Postby leocaza » Thu Nov 08, 2018 10:39 am

Hi,

Could you assist me unstacking data? I'm getting an error message when I try to unstack : "series specified for unstacking does not have valid values for
forming series names in "PAGEUNSTACK(PAGE=MYNEWPAGE,N
AMEPAT =*_?) BENCHM_LABEL CUR_CD VALUE_DT @ *".
"


Thank you

leocaza
Posts: 18
Joined: Mon Nov 27, 2017 7:18 am

Re: Unstacking data

Postby leocaza » Thu Nov 08, 2018 10:40 am

In my id there is Uppercase, "_" and letters.

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

Re: Unstacking data

Postby EViews Gareth » Thu Nov 08, 2018 11:49 am

Which version of EViews?
Follow us on Twitter @IHSEViews

leocaza
Posts: 18
Joined: Mon Nov 27, 2017 7:18 am

Re: Unstacking data

Postby leocaza » Thu Nov 08, 2018 12:38 pm

Hi Gareth,

I figured it out.


I did replace(replace(replace(replace(VARIABLE,' ','_'),'é','e'),'''',''),'à','a') and it worked.

English vs. french...

Thanks for your help.

I'm on Eviews 10

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

Re: Unstacking data

Postby EViews Gareth » Thu Nov 08, 2018 1:00 pm

@makevalidname might be useful too (quicker to inplement, not as nice output).

http://www.eviews.com/help/helpintro.ht ... dname.html
Follow us on Twitter @IHSEViews

leocaza
Posts: 18
Joined: Mon Nov 27, 2017 7:18 am

Re: Unstacking data

Postby leocaza » Thu Nov 08, 2018 3:09 pm

Omg, thank you Gareth


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 12 guests