How can I stack data into pivot form

For questions regarding programming in the EViews programming language.

Moderators: EViews Gareth, EViews Jason, EViews Moderator, EViews Matt

Posts: 9
Joined: Fri Nov 30, 2018 9:31 pm

How can I stack data into pivot form

Postby chairake » Tue Jan 08, 2019 2:36 am


I would like to know is there a way to command time series data into stack data like pivot form as example below

If I can command directly to simple platform as I show in the picture please tell me.

thank you so much


I have 3 form of sale data in different material and region

while (*) are names of material that are a,b,c,d
(**) are region that are wk,me,e,w,n,ne,s

Here is the stack data form I want
ID01 Var01 (Material) Var02 (Region) Vol Growth MA3
2000m1 A wk 100 2% 1%
2000m2 A wk 110 1% 0%
2018m12 A wk 200 5% 0%
2000M1 B wk 500 4% -3%

and so on
Capture.PNG (12.62 KiB) Viewed 104 times

Return to “Programming”

Who is online

Users browsing this forum: No registered users and 5 guests